Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 Dec 2004 @ 17:22:32 GMT


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


Subj:   OLE-DB TOOL
 
From:   McBride, Michael

I am trying to migrate a small (43,000 rows) oracle 8i table onto Teradata. My problem is that one of the columns is defined as DECIMAL(20,0). OLETOOL creates a table with DECIMAL(18,0) and I lose 21,000 rows to the error table due to numeric overflow. I tried making the destination a float, but when I make the Fastload define as a float, the column is populated with a zero value (all rows).

Is there any way to convert this value through the OLETOOL (TTU 7.1)?

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner



     
  <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