You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Incorrect Answer
2
Views
1
Comments

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.)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!