Duplicate records are frequently found in source data. The Remove Duplicates Mapping template helps you to remove duplicate data from source tables. This template helps you to maintain only one version of the data in the target database.

For example, your organization acquires another organization and both the organizations have many common customers. When you update the database, you need to remove the duplicate information, based on attributes like name and address of the common customers. You can use the remove duplicates template to remove duplicate information of the common customers and keep the database updated.