In a Star Schema, the fact table is surrounded by _______ tables.
- Dimension
- Lookup
- Reference
- Satellite
In a Star Schema, the fact table is surrounded by Dimension tables. Dimension tables contain descriptive attributes and provide context to the measurements stored in the fact table. This design enhances query performance by simplifying joins and optimizing data retrieval for analytical queries.
Loading...
Related Quiz
- What is the result of applying aggregation functions to a dataset in a database?
- A Data Mart typically focuses on a specific _______ area.
- What is version control in data modeling?
- How does indexing improve query performance in a database?
- In Reverse Engineering, what challenges might arise when inferring a conceptual data model from an existing database schema?