Informatica Developer: Filter Duplicate Records
Posted by: Pooja Shet
An Informatica Developer mapping example to remove duplicate records from the flat file.
Overview
More than often, our source data is far from perfect. Having duplicate records is a common anomaly in your source data. Finding duplicate records become all more challenging in the case of Flat file source.The mapping example available in the download file demonstrates a way to segregate duplicate and non-duplicate records in the source.Consider the input from the flat file Customer_master. There are unique and duplicate records in the source and you want to separate the duplicate records from the Non-duplicate records.Unique and duplicate records should be written to separate output files
Features
- Informatica Developer 9.5.1