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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Create an ODI mapping for upsert (insert and update).

Rajneesh S-OracleApr 24 2021 — edited Apr 24 2021

Hello All,
I want to create an ODI mapping for upsert (insert and update).
What are options to consider for updating a records based on column Code and GID. I mean if combination of values in column Code and GID exists in target then update values in remaining columns of the records. Also mapping should insert any new record in to the target.
I guess I need to select Code and GID as update_key, how ever in dropdown list getting only one option:ODS_POL_POLICIES_PK which is primary key (ID column in this case).
image.pngThanks,
This post has been answered by Christyxo on Apr 24 2021
Jump to Answer

Comments

Post Details

Added on Apr 24 2021
#business-intelligence-applications, #data-integrator, #system-management-and-integration
1 comment
1,224 views