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

Using Changed Data Capture (CDC) - consistent set

Unlike the simple CDC method demonstrated in the previous section, the use of consistent set CDC does address the problem of how to coordinate the flow of data into a target system when there are explicitly defined foreign key relationships between one or more target tables. One possible problem with simple CDC is that while you are processing changes for the parent records, more data can arrive, possibly including both parent and child records. In this case, once you are done processing the parents, you want to make sure that the children records that you will process belong only to these parents, and that the children that have arrived in the middle of your processing will only be processed with ...

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