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
- Spring '11
- Data warehousing, Star schema, Birla Institute of Technology and Science, Pilani Distance Learning