Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2011 @ 14:03:30 GMT

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

Hi Suhel,

The restart logic is the reason, that FastLoad will not load duplicate rows into a MULTISET table.

During Restart of Fastload, Some more records may be sent to amp again after the check points which is recorded at the point of failure.

So these records were filtered as dupicate records after the sort in phase 2 of fastload.

That's why the fastload does not allow duplicates even if we have a mutliset table.

Regards

John

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