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
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 347 what is hybrid slowly changing dimension?
What are the types of partitioning?
What is multi-dimensional analysis?
How can we do data cleaning?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is Molap and Rolap? What is Diff between Them?
Explain the data type of the surrogate key?
Explain functional dependency?
How are models actually derived?
Explain can a dimension table contains numeric values?
How to handle multi value dimensions?
What is a staging area? Do we need it? What is the purpose of a staging area?