Q1. Describe the structure of a data warehouse by using an appropriate figure.
Q2. Describe by using a small illustration the term partitioning of data. Describe in detail partitioning as a design approach for the data warehouse.
Q3. Describe the process of Normalization in warehouses. List out its merits?
Q4. Explain why is metadata essential for using, for building and for administrating the data warehouse?
Q5. Describe the complexities in the transformation and integration of data.
Q6. Illustrate the difference between local and global warehouses?