General Datawarehousing Question:

What is the Differences between star and snowflake schemas?

Tweet Share WhatsApp

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 PDF Read All 40 General Datawarehousing Questions
Previous QuestionNext Question
What is a lookup table?Explain What is real time data-warehousing?