Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2011 @ 10:22:48 GMT

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

Where does rejected duplicate records stored during the multiset table load in fast load?

Believe we get the summary report like below after the successful run of fast load.

     Line 1: TOTAL RECORDS READ = 1000000
     Line 2: TOTAL ERRORFILE1 = 40
     Line 3: TOTAL ERRORFILE2 = 0
     Line 4: TOTAL INSERTS APPLIED = 999950
     Line 5: TOTAL DUPLICATE ROWS = 10

My question is where I can find these10 duplicate rows? How do we trouble shoot if we come across this situation?

Please provide your expert guidance..:-)

Thanks

John

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