Chapter 6. Inside Knowledge Modules – SCD and CDC
In this chapter, we will cover the following topics:
- Implementing Slowly Changing Dimensions (SCD) using ODI
- Modifying an Slowly Changing Dimensions KM to allow undefined behaviors
- Using Changed Data Capture (CDC) - simple
- Using Changed Data Capture(CDC) - consistent set
- Using a single interface to load changes that occur in any dimension
Introduction
Since ODI is frequently used during data warehouse load operations, it is only natural that the functional requirements of Slowly Changing Dimensions (SCD) and Changed Data Capture (CDC) be addressed as part of its core functionality. By encapsulating the complexities of these two methodologies within the delivered set of KMs, ODI allows the developer to ...
Get Oracle Data Integrator 11g Cookbook 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.
