Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2009-2010 Comprehensive Examination (EC-2 Regular) Course No. : SS ZG515 Course Title : DATA WAREHOUSING Nature of Exam : Open Book Weightage : 60% Duration : 3 Hours Date of Exam : 03/04/2010 (AN) Note: 1. Please follow all the Instructions to Candidates given on the cover page of the answer book. 2. All parts of a question should be answered consecutively. Each answer should start from a fresh page. 3. Mobile phones and computers of any kind should not be used inside the examination hall. 4. Use of any unfair means will result in severe disciplinary action. Q.1. Why it is important to transform the data before it is loaded onto the data warehouse? List the type of transformations that are performed.  Q.2. What are the ways of improving query performance in a data warehouse environment? Give details.  Q.3. Devise a partitioning strategy for a bank data warehouse. Give your design first
This is the end of the preview. Sign up
access the rest of the document.