Hi All,
There are some options available in OWB that are not migrated to ODI 12c. One of them is the “Target Filter for Update” within the “Conditional Loading” property as we can see from the following URL: https://docs.oracle.com/middleware/1213/odi/install-migrate-owb-odi/app_mig_operators.htm#ODIMG346
This option allows the inclusion of conditions within the ON clause of the MERGE so you can use columns that are not mapped in the target. I cannot see any equivalent feature in ODI, am I missing something?
I think the cleanest way of reproducing the same behaviour is by customising knowledge modules. A new option for IKM Oracle Incremental Update (MERGE) to include custom code within the ON clause in the “Merge Rows” task will work.
Thanks,
Jose