MERGE SQL Not Generated by ODI for Migrated OWB Mappings Having 'Target DML Type=Update/Insert' and Property 'Match by Constraint=NO_CONSTRAINTS'
(Doc ID 2036791.1)
Last updated on MAY 03, 2021
Applies to:Oracle Warehouse Builder - Version 22.214.171.124 and later
Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
After migration of OWB mappings to ODI, ODI does not generate the merge statement when OWB merge mappings have following design characteristics:
- DML Type UPDATE/INSERT (MERGE)
- Match By Constraint: NO_CONSTRAINTS
- Loading properties for matching/update/insert have been set on the target
- Mapping PL/SQL generation working fine in OWB 188.8.131.52: MERGE SQL is generated correct
Migration of OWB mappings to ODI.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document