Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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..:-)


Thanks

John



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