In a star schema, what is the relationship between fact and dimension tables?
- Many-to-many
- Many-to-one
- One-to-many
- One-to-one
In a star schema, the relationship between fact and dimension tables is one-to-many. This means that for each record in the fact table (containing transactional data), there can be multiple related records in the dimension tables (containing descriptive attributes). This structure enables efficient querying and analysis of data in a data warehouse environment.
Loading...
Related Quiz
- In Forward Engineering, what is the initial step after creating a conceptual data model?
- In NoSQL databases, what is the significance of the CAP theorem regarding data consistency?
- The use of version control systems is crucial in managing changes during both Forward and Reverse Engineering to ensure _______.
- How does aggregation improve query performance in a database?
- To optimize performance in a Key-Value Store, _______ techniques may be employed.