What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to export mappings to the production environment?
What are target types on the server?
What are Non-additive facts?
Briefly state different between data ware house & data mart?
What are the design methods of data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is a fact, dimension, measure?
What are the data types present in bo? What happens if we implement view in the designer n report?
What is the use of dimensional modeling in data warehousing?
What is the difference between view filter and report filter?
Which columns go to the fact table and which columns go the dimension table?
what is difference between drill & scope of analysis?