What is the difference between star and snowflake schemas?
- 1 Answers
- 1366 Views
- I also Faced
- E-Mail Answers
Answer Posted / Hina Jain
The main difference between a Star Schema and a Snowflake Schema lies in their normalization level. A Star Schema is less normalized, with fact tables at the center connected to dimension tables through foreign keys. Each dimension table contains all possible values for its attributes. On the other hand, a Snowflake Schema is more normalized, where dimension tables are further sub-divided into smaller tables, reducing data redundancy.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
