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 FEBRUARY 28, 2019
Applies to:Oracle Warehouse Builder - Version 220.127.116.11 and later
Oracle Data Integrator - Version 18.104.22.168.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 22.214.171.124: 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