General Datawarehousing Question:

Download Job Interview Questions and Answers PDF

What is the Differences between star and snowflake schemas?

General Datawarehousing Interview Question
General Datawarehousing Interview Question

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?