Chapter 12. Data Integration Development Cycle Case Study
The last section of the Wheeler order management data integration project case study is the development phase, which will consist of two key development tasks:
- Prototyping cross-functional key logic, the common customer key
- Building a unit test case for one of the source system extract jobs
Step 1: Prototype the Common Customer Key
Because many organizations have multiple customer information files and databases, one of the most complex tasks in data warehousing is determining how to link all the customer files together in a common customer key.
In fact, common customer data is such a critical requirement to organizations that the discipline of Master Data Management emerged.
Unfortunately, ...
Get Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
