Discussion Questions
Q1 - Fact Table Grain
Define and provide examples of the three fact table grains. What are differences between fact and dimension records? What is the importance of designing robust dimension attributes?
Q2 - Fact Table Deliverables
Discuss the deliverables of the data warehouse design phase. What is the importance of the data mapping document? What information should be included in this document?
Q3 - Technical Architecture
Why is the technical architecture important to a data warehouse? Discuss the back room and front room components in relation to the technical architecture.