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?
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed