What is the difference between snowflake and star schema?
- 1 Answers
- 1145 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rajat Pratap Singh
Snowflake Schema is an extension of Star Schema where the fact table in a star schema is further normalized by breaking down larger dimension tables into smaller, more detailed tables. This results in a more complex structure with multiple levels of hierarchy resembling a snowflake. The main difference lies in the normalization level and the resulting complexity.
| 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
What is the purpose of Dataware Control?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
