Truncate the Data size to avoid "ORA-12899: value too large for column" in ODI

Summary:

We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only we can't increase the size of the varchar2 data type and can't even change the data type as the file doesn't support CLOB datatype.

The best option we are can across is to use the LKM formatting properties "TRUNCATE_COLUMNS" which will do the following (If the data in the file is too long for a field, then this option will truncate the value of the field rather than reject the row.)