Data Warehousing Question:
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.
A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.
| Previous Question | Next Question |
| How do you create Surrogate Key using Ab Initio? | What is a CUBE in data warehousing concept? |