Archives of the TeradataForum
Message Posted: Tue, 07 Jun 2005 @ 13:18:45 GMT
<-- Anonymously Posted: Tuesday, June 07, 2005 09:19 -->
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 ?.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|