Archives of the TeradataForum

Message Posted: Thu, 30 Nov 2006 @ 10:17:35 GMT

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

David,

Since you are extracting all your data and loading it to empty table, try extracting the oracle data onto flat files, delimited. Now load it using FastLoad. Compare the load times. The other option would be using Ole Load or warehouse builder but they use odbc and I doubt they will be faster than the named pipe. Also when using the pipes, I will check on permission and delete it when done loading.

HTH.

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