What is the difference between star schema and snowflake schema in data warehouse design?
meda Selected answer as best 20/10/2022
Both star and snowflake schema’s are multidimensional data model techniques for designing a data warehouse.
Star schema: It is a star like data model where there is a fact table at the center references multiple dimension tables. And the dimension tables are not normalized.
Snowflake schema: It is similar to star schema model but the dimension tables are further normalized into multiple related tables.
meda Selected answer as best 20/10/2022