This preview shows page 1. Sign up to view the full content.
Unformatted text preview:  Q.2 Why it is recommended to have finest granularity data in the data warehouse? What are the advantages and disadvantages of doing so?  Q.3 Explain why most data warehouse implementations are closer to Kimball’s bottom-up approach? What other alternatives approaches are available?  Q.4 What are the advantages and disadvantages of using the relational database technology in data warehousing?  Q.5 A dimension can appear many times in a fact table. What kind of problems this can cause? Discuss how such situations are handled in dimensional modeling? Give an example.  ******* No. of Pages = 1 No. of Questions = 5...
View Full Document
This note was uploaded on 02/05/2012 for the course CSE ss zg513 taught by Professor Raj during the Spring '11 term at Birla Institute of Technology & Science, Pilani - Hyderabad.
- Spring '11