![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Mon, 07 Mar 2011 @ 11:17:34 GMT
hi 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
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||