My Oracle Support Banner

Unexpected Behavior after Migration from OWB using the OWB to ODI Migration Utility (Doc ID 1962392.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Oracle Warehouse Builder - Version to [Release 11.2]
Information in this document applies to any platform.


There are some unexpected behaviors after migration from Oracle Warehouse Builder (OWB) using the OWB to Oracle Data Integrator (ODI) Migration Utility like:

- A column connection mismatch after the splitter component in ODI.

e.g Splitter attribute is mapped to following column in the table instead of the corresponding one.

- OWB mapping input parameter component attribute's default values are not migrated: default input parameter attribute values in OWB are not migrated as default values in ODI variables.

- When a OWB mapping has multiple pre and post mapping operators  and post migration to ODI, the ODI mapping BEGIN and END mapping SQL has only one references to Procedure calls

- Pre_map procedure generates wrong code after migration to ODI 12.1.3




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.