HOW TO LOAD DATA FROM FLAT FILE CONTAINING COLUMN LENGTH GREATER THAN 4000 CHARACTERS USING ORACLE DATA INTEGRATOR( ODI)

ODI default flat file string length is set to Varchar2 (4000 char).

To Load the data of column having more than 4000 characters, we need to change that to CLOB by following below changes in ODI.


     1.  Go to Topology Tab-->Physical Architecture-->Technologies-->File-->DataTypes
     2.  Go to String  Open "Converted To" tab and change the datatype to CLOB and save.