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

Last updated on JUNE 28, 2016

Applies to:

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 :

• mixed case or
• lower case.

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:

• In ODI 10g:
   
  
  • Command on source:
     

Cause