Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2005 @ 13:18:45 GMT


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


Subj:   Moving huge data from UDB to Teradata
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, June 07, 2005 09:19 -->

Hello All,

Our company is in the process of moving a huge amount of data (8-9TB) from a UDB server to Teradata. We are analyzing different approaches to complete this. A couple of options are to use an ETL tool to pull data from the source and load directly to the target. Other is to FTP data from the source and then load.

Is there anyone who has prior experience with such a situation ?. Any advice ?. Would it be a better option to load using the ETL tool as opposed to FTPing the data ?. Any pitfalls ?.

What sort of performance shoudl we expect using both these methods ?. Is it better to use OLE Load utility or Fastload ?.


Thanks



     
  <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