DATA WAREHOUSE Questions and Answers

What are the differences between star and snowflake schema?

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