Interested to Buy Any Domain ? << Click Here >> for more details...
When should you use a STAR and when a SNOW-FLAKE schema?
- 6 Answers
- 49853 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
Why facts table is useful in representing the data?
Can we start and stop single session in concurent bstch?
what is user variable in affinium campaign? and some real time examples.
What are data modeling and data mining?
Explain why denormalization is promoted in universe designing?
What is the difference between drill through and masterdetail reports?
what are the all possible features supported modify stage?
Explain piconet?
Where the applications and where ware house management system is used?
How to stop a batch?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain dimensional modelling?
What is a staging area? Do we need it? What is the purpose of a staging area?
Why should you put your data warehouse on a different system than your oltp system?
Explain can report net connect multiple datasource at a time in report creation time?
