Explain Differences between star and snowflake schemas?
Submitted by: Administratorstar schema is a logical structure that can be arranged with fact and dimension tables
in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Star Schema: can have less number of joins.
Snow flake: can have more number of joins.
Star Schema : has data redundancy, so the query performace is good.
Snow flake: is normalized, so does not has data redundancey. can have perfomance issues.
Submitted by: Administrator
in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Star Schema: can have less number of joins.
Snow flake: can have more number of joins.
Star Schema : has data redundancy, so the query performace is good.
Snow flake: is normalized, so does not has data redundancey. can have perfomance issues.
Submitted by: Administrator
Read Online Data Warehousing Basics Job Interview Questions And Answers
Top Data Warehousing Basics Questions
| ☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
| ☺ | Explain degenerate dimension table? |
| ☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
| ☺ | What are the Data Marts? |
| ☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
