Q1. Write down some of the reasons for the iterative development of data warehouse. As well describe the role of data model in the iterative development.
Q2. What is stored in the Meta data in data warehouse environment?
Q3. Define the OLAP cube. Illustrate its merits and demerits over relational technology.
Q4. Illustrate the four fundamental constructs found at the midlevel data model? Describe it with the help of an illustration.
Q5. Describe the features or characteristics of the data warehouse?
Q6. Distinguish between the Star Schema, Snowflake Schema and fact constellations with the help of a diagram.
Q7. What are the issues associated to the use and storage of external data in data warehouse? As well illustrate the methods to capture and store the external information.