Archives of the TeradataForum
Message Posted: Wed, 21 Apr 2010 @ 20:40:19 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|