Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2010 @ 20:40:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I have a table which contains a Data element with Varchar (64000); we are using Abintio/Multiload to load the data into warehouse. When the data is loaded into the large attribute it throws the error since the string length is more than 31000 it tries to truncate data which causes the failure. We can t use the Using clause while loading to make use of 64000 characters since Abintio builds the script in background automatically. I have a data which is more than 64000 characters for the some of the rows. I am thinking the below are the options and please advice the best solution if any.

1. Change the Data type from Varchar(64000) to CLOB

2. Split the large column into two discrete columns

Regards,

Hanumath

	<Prev	Next>		<<First	<Prev	Next>	Last>>