Data Modeling Question:
Download Job Interview Questions and Answers PDF
What is the difference between star flake and snow flake schema?
Answer:
Star Schema:
Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.
SnowFlake:
Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.
Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.
SnowFlake:
Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.
Download Data Modeling Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Give us a non-computer example of preemptive and non-preemptive scheduling? | What is data sparsity and how it effect on aggregation? |