Data integration and consolidation

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.



Looking for help with your homework?
Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Title Page
Place an Order

Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -