Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 17 Sep 2013 @ 22:17:31 GMT


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


Subj:   Re: TPT stream operator/Tpump - Duplicate records.
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, September 17, 2013 16:05 -->

Under the covers the pack is rejected and the records retried until only the actual duplicates wind up in the reject table.

STREAM should handle deadlock and retry, but yes it is possible. Look at using SERIALIZE ON a subset of the PI to minimize this.



     
  <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: 24 Jul 2020