Duplicates in Fastload

Tools & Utilities

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 error
tables.Only on the output screen we can see.Please let me know any ideas.


Re: Duplicates in Fastload

You cannot see them in Fastload at all. The only indication it has happened is:
Records Read: 110
Records Loaded: 100
and 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.