Archives of the TeradataForum

Message Posted: Tue, 18 Jan 2005 @ 06:19:17 GMT

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

If your data were to be badly skewed(i.e. considering NUPI) and you have a SET table to be loaded then MLOAD takes a longer time - because it checks every row to be inserted for duplicates. Added to this error logging (logging the duplicate row to the error table) would again take some cosiderable time. You could avoid this if you were to have a MULTISET table as the target table to be loaded.

Fastload however does not allow duplicate rows even though the table is MULTISET (it handles the elimination internally).

Narayan

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