Skip to Main Content

SQL & PL/SQL

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!

ODI - Oracle data integrator - Incremental update - MERGE.GLOBAL

User_NHK9OJan 16 2023

Hello,
i have an issue in oracle data integrator (odi), i try to import orders ( only the newest) from sfdc to oracle and i have a trasmission_date field in oracle table to populate when a record is update or inserted.
Each time i run the mapping in odi trasmission_date is populated, with the today date, not only for the newest salesforce orders present in source but also for the oldest records not passed but already in oracle table.
Any idea how solve this problem?
ERROR_ODI.png
thanks for your help

Comments
Post Details
Added on Jan 16 2023
0 comments
288 views