Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2011 @ 11:17:34 GMT

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

hi

fast load informs the number of duplicate records but it does not store those rows anywhere.

in my opinion there is no way where we can find these duplicates rows.

if you really want to know those rows that there is one alternative which we can use , make all the columns of the table as UPI, then load data with the help of fastload. Now the duplicate rows will cause an UPI violation and will be stored in error tables for further processing.

Thanks & Regards

Nitin Agarwal

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