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

Implementing Slowly Changing Dimensions (SCD) using ODI

If the reader is familiar with the fundamentals of data warehouse design, there should already be an understanding of three basic forms of dimension management:

  • Type-I: No historical data (new record data replaces the old data)
  • Type-II: Complete historical data (with start and end date bracketing)
  • Type-III: Limited historical data (only the most recent data is kept)

Note

There are other SCD methods (that is history tables, hybrids, and so on) not mentioned, but due to the infrequency of their use or lack of support by ODI, they have been omitted from this discussion. It is not within the scope of this book to discuss the advantages, disadvantages, and reasons for using any of these SCD formats, ...

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