Enterprise Data Warehouse Interview Question:

Explain the main differences between star and snowflake schema?

Submitted by: Administrator

Star schema: A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.

star schema: in this we have the centrally located fact tables surrounded by the number of dimensional tables where as in snow flake schema a denormalized dimensional table is subdivided into child dimensional tables
Submitted by: Administrator