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

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