What Are The Differences Between Star And Snowflake Schema?

1.	What Are The Differences Between Star And Snowflake Schema?
Answer» STAR schema: A single FACT table with N NUMBER of DimensionSnowflake schema: Any DIMENSIONS with extended dimensions are known as SNOWFLAKE schema. Star schema: A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.

Answer»

STAR schema: A single FACT table with N NUMBER of DimensionSnowflake schema: Any DIMENSIONS with extended dimensions are known as SNOWFLAKE schema.

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

Discussion