In a star schema, if a dimension table contains a hierarchy of attributes (like Year > Quarter > Month), but these attributes are not broken into separate tables, this design is contrary to which schema?
- Fact Constellation Schema
- Galaxy Schema
- Hierarchical Schema
- Snowflake Schema
In a star schema, dimension tables are typically denormalized, meaning that hierarchies of attributes are not broken into separate tables. This design is contrary to the snowflake schema, where attributes are often normalized into separate tables to reduce redundancy. In a snowflake schema, the Year, Quarter, and Month attributes might be split into separate tables, leading to more complex joins.
Loading...
Related Quiz
- How does a data mart differ from a data warehouse in terms of data integration?
- In cloud environments, data redundancy and high availability are often achieved through _______ across multiple zones or regions.
- In the context of data warehousing evolution, the shift from batch processing to real-time processing was a significant step towards _______.
- When considering Data Warehousing, _______ is a subset of the data warehouse, particularly suited to a specific business line or team.
- When discussing OLAP, which operation provides a summarization of data, increasing the level of abstraction?