When to use snowflake and when star schema?

This question is also very common on interviews, but it is also essential part of Data Warehouse design. Star schema In star schema dimensions that reflect a hierarchy are flattened into a single table. For example in a star schema Product Dimension would have columns like Product Line, Model, Inventory in one denormalized table, but … Continue reading When to use snowflake and when star schema?