This preview shows page 1. Sign up to view the full content.
Unformatted text preview: domains?  Q.3. What, according to you, are the drawbacks of starting a data warehouse project by building data marts? Also explain how Kimball overcame these shortcomings.  Q.4. Compare & contrast outriggers & mini-dimensions. Give situations under which you would prefer an outrigger to a mini-dimension & vice versa.  Q.5. Explain the entire process of populating and refreshing dimension and fact tables in a data warehouse. First identify the steps involved in chronological order and then give detail of each step involved. Also draw a flow-chart for the same.  Q.6. Design star schema(s) to find out products which were on promotion but did not sell. Give an SQL statement for the same. Give an elaborate design of the promotion dimension and also discuss the granularity of your schema(s) in detail.  ******** No. of Pages = 1 No. of Questions = 6...
View Full Document
- Spring '11