Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the difference between dw and bi?
What should I have in mind when building olap solution from scratch?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is the difference between power center and power mart?
What is the "junk dimension"? Give with examples?
What are session timeout and application timeout? Where we have to do this process?
Explain what is the difference between olap and datawarehosue?
Explain what is the advantages data mining over traditional approaches?
what role views play in dimensional modeling?
How do we design a universe?
Explain some of modeling tools available in the market?
what is the use of surrogate key in businessobjects