Explain what are snapshots? What are materialized views & where do we use th

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

Question Posted / murali

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

More Data Warehouse General Interview Questions

Explain difference between snow flake and star schema.

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

Whether dimension table can have numeric value?

How are models actually derived?

What are the types of partitioning?

How much data hold in one universe.

What is the differences between star and snowflake schemas?

What is a look up function? What is default transformation for the look up function?

What are the possible data marts in retail sales?

What is ods (operation data source)?

What is XMLA ?

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

For more Data Warehouse General Interview Questions Click Here