Archives of the TeradataForum
Message Posted: Mon, 07 Mar 2011 @ 10:22:48 GMT
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..:-)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|