Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Handling of duplicate records in Fast load
From:   Jepamony, Johnpaul

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..:-)



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023