Q1. Data warehouse is a blend of technologies. Do you concur with this statement? Illustrate your arguments.
Q2. Describe in detail the merits and demerits of Top-Down versus Bottom up approach of the data warehouse design.
Q3. What do you mean by Partitioning of data? Describe the ways to carry it out by giving appropriate illustrations.
Q4. Describe the warehouse architecture in detail.
Q5. List out the main functions and services for the information delivery? describe each in brief.
Q6. A dimension table is wide; the fact table is deep. Illustrate.
Q7. Describe the merits of STAR schema.
Q8. Describe the term Normalization in data warehouse. List all its merits.