CS614– Data Warehouse - Midterm Paper 2012
Fall Spring
Dated May 22,2012Time 1 hour
Tuesday, May 22, 2012 at 1.06 PM,
Total Question is 26
MCQ 20
Short 6
MCQs are mostly news but easy to understand.
1. How to gain expressionless?
2. Difference between one to one and one to many transformation (2)
3. In the given scenario What are the additive and non-additive and reason?
| S.no | No. of Item Sold |
| 1 | 20 |
| 2 | 50 |
| 3 | 40 |
| Total | 110 |
| S.no | No. of Item %Discount |
| 1 | 41 |
| 2 | 52 |
| 3 | 46 |
| Total | 249 |
4. What is HOLAP and its features?
5. You are manager of DWH, how you keep the data Validate in term of secure data of Validation:
6. purposes data profiling
