Data Warehouse and Data Marts
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. Why did the idea of a data warehouse emerge?
2. What is the distinction between a data warehouse and dimensional modelling?
3. Which data warehouse modelling approach, popularised by Bill Inmon, emphasises integration and normalisation to minimise redundancy?
4. In dimensional modelling, what does a fact table keep?
5. What is a conformed dimension?
6. Which modelling approach structures data into hubs, links and satellites to support historical tracking and auditability?
7. What is the main difference between a data warehouse and a data mart?
8. How did Bill Inmon define a data warehouse in 1990?
9. How do the approaches of Bill Inmon and Ralph Kimball differ in building order?
10. Why does the author of I Am Datapedia! prefer building the enterprise warehouse before the data marts?