Case Sensitivity Of Header Records Is Lost After Update Of "IKM SQL To File Append" With ODI 11g Mandatory Changes (Doc ID 1684203.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After having upgraded from Oracle Data Integrator (ODI) 10g to 11g or 12c, and having updated the knowledge modules with the mandatory changes, the IKM SQL To File Append no longer writes the header records of target File when it is to be wriitten in either :

For example, a File Datastore defined with one header row, and following column names:

mycol1        (observe lower case letter is used)
MyCol2        (observe mixed case letter is used)
MYCOL3        (observe upper case letter is used)

The header record before upgrade to ODI 11g was generated with the exact names above (respecting the type case)...

... while in ODI 11g, with the updated IKM, the header row is set in upper case only :

MYCOL1        (observe upper case letter is used instead of expected lower case)
MYCOL2        (observe upper case letter is used instead of expected mixed case)
MYCOL3        (observe upper case letter is used)

Changes

The code implemented in the Generate header step of referred IKM differs between ODI 10g and ODI 11g:

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