What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
- 1 Answers
- 1262 Views
- I also Faced
- E-Mail Answers
Answer Posted / Nishant Saxena
The main difference between Snowflake Schema and Star Schema lies in their normalization level. Star Schema has a denormalized design with minimal joins, whereas Snowflake Schema is more normalized and may require multiple joins. Situations where Snowflake Schema might be better than Star Schema include: 1) Reducing data redundancy for large fact tables with fewer foreign keys. 2) Simplifying ETL processes by allowing the separation of closely related dimensions into sub-dimensions. However, the opposite is true when dealing with simpler data structures or when reducing join complexity is a priority.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the purpose of Dataware Control?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
