My Oracle Support Banner

Why Does Modifying a Primary Key Column in a CDC Mapping Insert a New Row to the Target Table? (Doc ID 2996022.1)

Last updated on JANUARY 03, 2024

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


After performing the following:

  1. Set up Oracle Data Integrator (ODI) Change Data Capture (CDC) for table model
  2. Create simple table to table mapping
  3. Confirm that inserting a new row in the source table results in a new row inserted in the target table
  4. Modify a primary key column value in the source table
  5. Verify result in the target table

Why does modifying the a primary key column value in the source table insert a new row in the target table instead of modifying the corresponding row?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.