Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

What are algorithms provided by Microsoft in SQL Server?

0 Answers  


what is the difference between DSS and ODS ?

2 Answers   IBM, Satyam,


what is user variable in affinium campaign? and some real time examples.

0 Answers  


What are aggregate tables and aggregate fact tables?

0 Answers  


What are the steps involved in designing a fact table?

0 Answers  






How much data hold in one universe.

0 Answers  


Why denormalization is promoted in universe designing?

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.

0 Answers   IBM,


Are facts same as metrics and dimensions same as measures? If not , please tell the difference?

1 Answers   Patni,


Explain how to export mappings to the production environment?

0 Answers  


How to handle multi value dimensions?

0 Answers  


Explain the difference between filter and conditin?

0 Answers  


Categories