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
How can we schedule the graph in unix?
in general which algorithms for used?
Explain normalization?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is your spectra photometer working principles?
What are the various transformation available?
what are relationships?
What are the different types of datawarehosuing?
What is dimensional modelling?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain why dimenstion tables are denormalized in nature?
Explain how to export mappings to the production environment?
Is union transormation is active transformation?