Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IKM Oracle Merge (Component-style) to perform only UPDATE

Jose VidalSep 12 2016 — edited Sep 13 2016

Hi All,

There are some instances where OWB generates a MERGE statement without the “WHEN NOT MATCHED THEN INSERT …” part.

I am trying to simulate exactly the same code in ODI 12c using the IKM Oracle Merge (Component-style knowledge module) but it always generates the INSERT part within the MERGE statement. I have been playing with the individual “Insert” checkboxes of the columns from the target but it keeps generating the code.

Is there any way to work around this issue without using a “Template-style” KM?

I know that I can easily customise the IKM Oracle Incremental Update (MERGE) to perform only UPDATEs but it's worth to check if Oracle provides any other route.

Thanks,

Jose
This post has been answered by Jasmine Pauline on Sep 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2016
Added on Sep 12 2016
#business-intelligence-applications, #data-integrator, #owb, #system-management-and-integration, #update
2 comments
353 views