Can some one please tell me how to handle duplicate records in BODS.

Hi, I am new to BODS and I have been asked to come up with a mechanism to handle duplicate recrods from flat files (fixed width text files) and send back the information via email to some of the receipients.