When should you use a STAR and when a SNOW-FLAKE schema?
Answer Posted / shivaleela
STAR SCHEMA:-if PERFORMANCE is the priority than go for
star schema,since here dimension tables are DE-NORMALIZED
SNOW-FLAKE SCHEMA:-if MEMORY SPACE is the priority than go
for snoflake schema,since here dimension tables are
NORMALIZED
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
What are aggregate transformation?
What is the difference between star and snowflake schemas?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain why dimenstion tables are denormalized in nature?
How can you set the client management?
How to calculate fact table granularity?
Explain swot analysis?
What are cluster analysis in data warehousing?
Name a few sectors which use data warehousing?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what is the data type of the surrogate key?
Describe the differences between a data warehouse and data mart.
What is perform recovery?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?