Archives of the TeradataForum

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

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

<-- 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>>