O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

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 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 ...

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