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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *