CS614 Midterm Past Paper Fall 2005

CS614- Data Warehousing

Midterm Fall2005

Give precise answer of the following questions. (5 each) ? What is the major transformation of Calculated and Derived Values? Calculated and Derived Values: ? Why bother about data duplication? Explain using an example. Data Duplication: ? Briefly explain the Summarization basic Data Transformation task? Briefly explain the following questions. (5 each) Onetomany Transformation: ? Why onetomany transformation is complex, give example?

? Define ETL. List three typical MIS/ERP systems that are found while doing ETL?

? What is the advantage of CDC in the context of "inflight" transformation? Write down short note on the followings: (5 each) known in advance. Typically, in Decision Support System, the data access is ad AdHoc access means that the pattern in which the data will be accessed is not AdHoc access ER modelling: ? Why ER Modelling has been so successful?

? What is meant by HOLAP? Why is it used?

HOLAP: