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

Post New Answer

More Data Warehouse General Interview Questions

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

0 Answers  


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

4 Answers   IBM, MAHINDRA, Tech Mahindra,


What are the possible data marts in retail sales?

0 Answers  


What is up date strategy and what are th options for update strategy?

2 Answers  


What are situations where snow flake schema is better than star schema to use and when the opposite is true?

0 Answers  






What are loops in Datawarehousing?

0 Answers  


What is Drill by? drill through?

1 Answers   CMC, iFlex,


Explain what are non-additive facts?

0 Answers  


What is DTM session?

1 Answers  


How to pivot data using informatica when you have variable amount of pivot rows?

0 Answers  


Explain what is difference between query studio and report studio?

0 Answers  


Explain how are the dimension tables designed?

0 Answers  


Categories