Last updated on AUGUST 15, 2017
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms