General Datawarehousing Question:

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.


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