*Midterm current paper of cs614(data warehouse.)*
Mcqs 18. 10 from past ans 8 new.
2 subjective questions having 3marks each.
3 subjective questions having 5 marks each.
Q1. 3 advantages of change data capture.
Q2. Tell Name of any three Data Quality assessment technique.
Q3. Selecrivity od DWH is low as compare to OLTP. Why ?
Q4. Explain Drill Down and Roll Up with example
Q5. Advantage of storing historical data in DWH.