ETL CLOB from Oracle to Teradata

UDA

Re: ETL CLOB from Oracle to Teradata

thanks carlos for the information =)

Cherry

Re: ETL CLOB from Oracle to Teradata

Hi,

while loading the data from CSV file to Teradata table, I am missing some data. please help me out

example:

Transformation_desc is the column in target table, which is having length varchar(4000).

transformation_desc is the column in file, length string(4000), which is sending 3400 length record only for loading into the table field transformation_desc. But 1770 bytes data only loaded into column field in the table.

3400 bytes data in Double quotes "..."

Thank you

Murali. 

Enthusiast

Re: ETL CLOB from Oracle to Teradata

Can anyone tell me how to load CLOB/BLOB data from Oracle to Teradata table using TPT? I am able to load CLOB data when I declare it as VARCHAR in teradata but it fails If I declare it CLOB or BLOB. Please help me.

Teradata Employee

Re: ETL CLOB from Oracle to Teradata