This preview shows page 1. Sign up to view the full content.
Unformatted text preview: and the circumstances under which they are justified. [4 + 4 = 8] Q.2 Most of the analysis has a time component. Explain what role time dimension plays in such analysis. Why it is recommended to have a separate time dimension rather than having the date as one of the attributes in the fact table? Where from does one get the time dimension?  Q.3 Why it is recommended that the dimension tables in a star schema be denormalized? What is the highest normal form of the dimension tables and the fact tables?  Q.4 What are inside-out and outside-in queries? What are dimension-focused and fact-focused queries? Give one example of each type of query.  Q.5 What are the strengths and weaknesses of the relational technology when it comes to using it for data warehouses?  ******* 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