when we go for snow flake schema rather than star schema ?
Answer Posted / murali
snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.
Draw-back: Slow performance for executing the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datawarehousing and businessintelligence?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Can you please send me the migration related issues .
how to prepare the documentation in business objects and where to get the requirement?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain how we drill up week to month?
Differences between business objects and web intelligence reports?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is the difference between business requirement document and use case document.
Explain what three things do you consider to be the most important factors for a manager?
Explain what task is 98% of the required work of a business analyst?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the difference between user and versatile user?
Can anybody tell me what are the tuning problems?