Upgrade To ODI 12c Changes The Order Of Reusable Mapping Target Datastore Columns (Doc ID 2290746.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.2.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

Having an Oracle Data Integrator (ODI) 11g Temporary Interface that reads data from a source File Datastore, using the out-of-box "LKM File to Netezza (NZLOAD)" knowledge module.

Since this LKM does not pass the File METADATA along with the data (/*$$SNPS_START_KEY..............$$SNPS_END_KEY*/), the order of columns in the source File Datastore must match the order of columns in the target Datastore.

Or, when upgrading to ODI 12c, the order of target Datastore columns in the _RMT and _RMS Reusable Mappings no longer matches the order of columns in the source File Datastore, therefore leading to either invalid data, or error messages if the type of columns are incompatible (for example, "Bad numeric input format 'my string' " when loading a string into numeric).

To illustrate the above, the screen copy below shows the order of columns in the 11g Temporary Interface:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms