Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 23 Oct 2007 @ 17:09:01 GMT


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


Subj:   Re: Unexpected behavior in Fastload
 
From:   Anomy Anom

<-- Anonymously Posted: Tue, 23 Oct 2007 11:56 -->

Note that FastLoad can only detect duplicate ROW not duplicate RECORD.

If the rows are entirely duplicate, FastLoad keeps one and eliminates the other (obviously, it makes no difference which one it keeps since they are identical).

If the PI is duplicate but the rest of the row is not, FastLoad will keep one and reject the other. It is NOT guaranteed to keep the one that occurs first in the input file.



     
  <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: 15 Jun 2023