Explain the main difference between inmon and kimball philosophies of data warehousing?
No Answer is Posted For this Question
Be the First to Post Answer
What is metadata in context of a datawarehouse and how it is important?
What is execution plan?
What is mean by aggregate aware?
what are different ways of loading data to data warehouse using oracle?
How are the dimension tables designed?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the data types present in bo? What happens if we implement view in the designer n report?
what is the difference between MOLAP and ROLAP?
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?
How can you clear the cache?
Explain the difference between data ware house & data mart?
What is perform recovery?