Week 3 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.