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.
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.