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
- Spring '11
- Data warehousing, Database normalization, time dimension, Fact table, Birla Institute of Technology & Science