Data Warehousing Question:
Download Job Interview Questions and Answers PDF
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.
Download Data Warehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How do you create Surrogate Key using Ab Initio? | What is a CUBE in data warehousing concept? |