Hello everyone,
i want set status on my target table.
When new record is inserted into my table, i want set 'I' to my change_status field.
And if there is row is existed, compare field values and something is different i will update, but my change_status field should be 'U'.
How can do this on ODI Mapping?
Example: Here's my source data
Here's my target data
There is 1 difference, on "MILES_BALANCE" column have different value. If there is any difference between 2 rows, i want update that row with new data. and set change_status field with 'U'. MEMBER_ID is my key column.
And if new rows inserted into target table. i want set "I" on change_status field.
Here's my mapping, i'm only storing 'I' value when new records is inserted.
