Interested to Buy Any Domain ? << Click Here >> for more details...
When should you use a STAR and when a SNOW-FLAKE schema?
- 6 Answers
- 50055 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nethaji
We use star schema when the query involves few joins and for
better performance.here data is denormalized.
Snow-flake schema is an extension of star where the
dimensions are divided into hierarchy of dimensions.eg: time
dimension.
time->year->month->day
For complex joins we go for snow-flake.performance is little
bit slower due to no. of joins.Here data is normalized.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What is called dimensional modelling?
What needs to be done while starting the database?
What is a hash cluster?
Explain is fact table?
How to create context?
What are cluster analysis in data warehousing?
What is dimensional modelling?
Explain can a dimension table contains numeric values?
What is cubes?
Explain about core dimension,
Where the applications and where
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain conformed fact?
What is the difference between data warehouse and operational systems?
Briefly state different between data ware house & data mart?
