Archives of the TeradataForum

Message Posted: Tue, 03 Jul 2007 @ 16:42:08 GMT

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

Simply put...FASTLOAD is limited in the range of transformational or data manipulation operations that can be performed on the fly... If you have MULTILOAD available, which will accommodate this, why not use it? If you are using FASTLOAD, then it is assumed that the target table is empty. While there is much that can be discussed in the area of load performance, for that situation the performance of MULTILOAD compared to FASTLOAD is generally quite comparable, all else being equal.......

Cornelius Meade III
EDS - Consulting Services/BI/CRM

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