Difficulty: Intermediate
Star Schema vs Snowflake Schema.
Star: Simple, denormalized dimensions for performance. Snowflake: Normalized dimensions for storage efficiency and data integrity (looks like a snowflake with branches).
DW, Facts, Dimensions
JavaScript is required for the interactive version of this page, including the code playground and progress tracking. Browse all InternHack tutorials.