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

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

0 Answers  


What we will do with the universe for faster process?

0 Answers  


How can we import and export using BCP utility?

1 Answers  


Why do we use DSS database for OLAP tools?

3 Answers  


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

0 Answers  






How would you write a left join statement to return a result set of movie.title�s and director.name�s?

0 Answers  


Why is dimensional normalization not required?

0 Answers  


how to find unique records in informatica level

1 Answers   IBM,


What are the difference between snow flake and star schema?

0 Answers  


Can we have multiple application.cfm file in an application?

0 Answers  


What is difference between Mapplet and reusable transformation?

3 Answers   UST,


What is meant by metadata in context of a data warehouse and how it is important?

0 Answers  


Categories