Interested to Buy Any Domain ? << Click Here >> for more details...
When should you use a STAR and when a SNOW-FLAKE schema?
- 6 Answers
- 50047 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / malli
usually star schema is the best option for end users due to
its simple design and navigation.
snow flaking is the process of normalizing the dimension
table.For example the customer dimension table usally will
have millons of rows.The updations will take palce
concerned to demographic information(city,place,..).By
snowflaking, these attribute can be seperated and put in
another dimension table, so the updations would be quite
easier.
| Is This Answer Correct ? | 11 Yes | 14 No |
Post New Answer View All Answers
What are loops in Datawarehousing?
What is the difference between Datawarehouse and OLAP?
Explain difference between view and materialized view?
What is the difference between power center and power mart?
Explain which are the olap tools available that are supported by oracle?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain the difference between oltp and olap?
Is there any rownum object from which we can do this?
What are data modeling and data mining? Where it will be used?
What is Sequence clustering algorithm?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
How we are using this function?
How to generate iqd file from framework manager?
What are vaious etl tools in the market?
What are the different methods of loading dimension tables?
