General Datawarehousing Question:
Download Questions PDF

What is the Differences between star and snowflake schemas?

Answer:

Star schema - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is a lookup table?Explain What is real time data-warehousing?