How do I modify an IKM in ODI 12c to prevent duplicates in a target table? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I modify an IKM in ODI 12c to prevent duplicates in a target table?

in Data Integration

Hi everyone,

I was practicing ODI 12c and I came across this problem:

I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table. The logical diagram is:

source: staging table -> FILTER -> EXPRESSION -> target: staging history table

In the physical tab of the mapping, I set:

EXPRESSION_AP: uses LKM SQL to Oracle (Built In).GLOBAL

staging history table: uses IKM Oracle Control Append for its IKM ( and CKM Oracle for its CKM

Let's say it's May 16th 2025 15:47:42.000, If I run the mapping once, a record will be inserted into the target table with its field 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!