This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: years’ sales data in our data warehouse. Estimate the size of the fact table in Giga bytes given that we have 3 facts (each of 4 byte length). Assume that there are four dimensions, namely, Product, Time, Location, and Promotion and surrogate keys are used in all dimension tables. It is also given that for each SKU we store only one record for a day from each store. (6) Q. 4. Describe how the promotion dimension is modeled in the Grocery store data warehouse. Also explain what are coverage tables and what relation they have with the promotion dimension. (6) Q. 5. What are fully-additive, semi-additive, and non-additive facts? Give one example for each in such a way that the concept becomes clear. (6) _________ No. of Pages = 1 No. of Questions = 5 This document was created with Win2PDF available at http://www.daneprairie.com. The unregistered version of Win2PDF is for evaluation or non-commercial use only....
View Full Document
- Summer '10
- Data warehousing, Star schema