Data warehouse repository

1. Name five types of the major transformation tasks. Give an example for each.

2. Describe briefly the entity identification problem in data integration and consolidation. How do you resolve this problem?

1. Explain the difference between destructive merge and constructive merge for applying data to the data warehouse repository. When do you use these modes?

2. When is a full data refresh preferable to an incremental load? Can you think of an example?

As the ETL expert on the data warehouse project team fora telecommunications company, write a memo to your project leader describing the types of challenges in your environment, and suggest some practical steps to meet the challenges.

 

Solution: