IICS and Oracle CLOB

Asked Jun 18 '22 at 14:36

Active Jun 18 '22 at 14:43

Viewed 267 times

Question on IICS :

Extracting data from a oracle CLOB datatype.
The CLOB field contains XML in it.
When extracting from Oracle using IICS, the source datatype is set to Text with the max field limit of 104857600.
The data is truncating right at the source (Noticed it at the transformation preview) at whatever datatype I get to use (text, next, nvarchar, varchar) .
The data will be loaded in Snowflake.

Any solution is greatly appreciated

Thanks, B

edited Jun 18 '22 at 14:43

asked Jun 18 '22 at 14:36

Bharath SP

What is the length of the source value? – Maciejg Jun 19 '22 at 11:17
Source is a oracle CLOB column. When I checked the length goes upto 112500. But it gets truncated at 47914 – Bharath SP Jun 19 '22 at 19:56

0 Answers0