This preview shows page 1. Sign up to view the full content.
Unformatted text preview: data warehouse architecture.  Q.2. Give situations under which there is a need to distort the classical star schema. Some DW access tools require classical star schema. How can we use such tools when the classical star schema is distorted?  Q.3. What is a coverage fact table? What purpose it serves in a grocery store sales data mart? Give a suitable schema of coverage fact table and discuss its granularity.  Q.4. What are the advantages and disadvantages of having finest granularity data in the data warehouse and data marts?  Q.5. What are the features and functionalities that a user should expect from an OLAP tool? Give a brief description.  ********* 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