Archives of the TeradataForum

Message Posted: Tue, 23 Oct 2007 @ 17:09:01 GMT

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

<-- Anonymously Posted: Tue, 23 Oct 2007 11:56 -->

Note that FastLoad can only detect duplicate ROW not duplicate RECORD.

If the rows are entirely duplicate, FastLoad keeps one and eliminates the other (obviously, it makes no difference which one it keeps since they are identical).

If the PI is duplicate but the rest of the row is not, FastLoad will keep one and reject the other. It is NOT guaranteed to keep the one that occurs first in the input file.

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