O'Reilly logo

Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture by Anthony David Giordano

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Prototyping cross-functional key logic, the common customer key
  2. 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required