while loading the data from CSV file to Teradata table, I am missing some data. please help me out
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 "..."
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.
Please have a look at following link: