What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
- 1 Answers
- 1156 Views
- I also Faced
- E-Mail Answers
Answer / Neelima Sagar
Snowflake Schema is an extension of Star Schema, where fact tables are connected to multiple related dimension tables through intermediate, or child, dimension tables. Star Schema is simpler with one fact table linked directly to each dimension table. Snowflake Schema is useful when dealing with complex relationships in a large database, while Star Schema is more efficient for smaller databases and simpler relationships.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the definition of normalized and denormalized view?
How can we do ETL process in SQL Server?
What is the difference between power center & power mart?
What are the design methods of data warehousing?
What are modeling tools available in the market?
What are the possible data marts in retail sales?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What should I have in mind when building olap solution from scratch?
What is source qualifier?
Explain what are the various reporting tools in the market?
Explain how are the dimension tables designed?
What is the "junk dimension"? Give with examples?
Teradata 
