What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema 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

What is analytical or analytic mean?

0 Answers  


What is Discrete and Continuous data in Data mining world?

0 Answers  


Explain what are conformed dimensions?

0 Answers  


what is the use of surrogate key in businessobjects

3 Answers   EDS,


Difference between PowerPlay transformer and power play reports?

0 Answers   CTS,






How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

0 Answers  


What is a fact table?

1 Answers  


Explain what is real time data-warehousing?

0 Answers  


how do you use commit frequencies? how does it affect loading performance?

1 Answers  


What are data modeling and data mining? Where it will be used?

0 Answers  


What is a ETL/ How does Oracle support the ETL process?

1 Answers  


What are session timeout and application timeout? Where we have to do this process?

0 Answers  


Categories