All Forums Tools
kiranparsha 16 posts Joined 04/09
23 Jul 2009
Duplicates in Fastload

Hi All,As Fastload does not allow duplicate records. But how to identify the duplicate records, those records were not loaded in errortables.Only on the output screen we can see.Please let me know any ideas.Regards,kiran

Jimm 298 posts Joined 09/07
23 Jul 2009

You cannot see them in Fastload at all. The only indication it has happened is:Records Read: 110Records Loaded: 100and no errors!If it is a real prblem, and you do not have too many records, use Multiload. It puts the duplicate records into an error table.Otherwise, you will have to use an inmod to put a sequence number on the records (thereby making the records unique), and then use SQL to identify the records with duplicates.

You must sign in to leave a comment.