What Is The Difference Between Star And Snowflake Schemas?

1.	What Is The Difference Between Star And Snowflake Schemas?
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