Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2011 @ 11:17:34 GMT

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

Subj:   Re: Handling of duplicate records in Fast load
From:   nitin.agarwa


fast load informs the number of duplicate records but it does not store those rows anywhere.

in my opinion there is no way where we can find these duplicates rows.

if you really want to know those rows that there is one alternative which we can use , make all the columns of the table as UPI, then load data with the help of fastload. Now the duplicate rows will cause an UPI violation and will be stored in error tables for further processing.

Thanks & Regards

Nitin Agarwal

  <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