Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c throwing Data Size issue

3715508Oct 2 2018 — edited Oct 2 2018

i am working on simple mappings from Source RDBMS To Datwarehouse db. Simple 1 to 1 mapping but upon execution, it keeps throwing error about column data is exceeding the available data size.

Source system is ORACLE OLTP

Target : OLAP DW

both system shows it uses NLS_LENGTH_SEMANTICS as BYTE so there is no change in data size i guess.

error : value too large for column "VJBI_ODIWORK"."C$_0S_CASE1"."DESC_TEXT" (actual: 2004, maximum: 2000)

I tried increasing column data size for one column but it throws error again for another one.

This is something i could not figure out..any support in this issue would be highly appreciated.

Regards

Added on Oct 2 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

4 comments

1,207 views