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:
Oracle Data Integrator - Version 11.1.1.3.0 and laterInformation 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 :
- 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:
- Command on source:
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