Search code examples
oracle-databaseoracle12coracle-data-integrator

issue with IKM for incremental update when using a sequence in target table


ENG_ENG_OPE is my target take a look at what I set for it:

logical : enter image description here

physical :

enter image description here

when I run this Mapping I get this error :

enter image description here


Solution

  • In the properties of the column with the sequence set the property Execute on Hint to Target this solved the problem

    enter image description here