Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Abintion/Mulitload Large text
 
From:   Padarthi,Hanumath

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016