To eliminate duplicate records from your data, you may choose to merge data from groups of duplicate records into a single "best of breed" record. This approach is useful when each duplicate record contains data of the same type (for example, phone numbers or names) and you want to preserve the best data from each record in the surviving record.
This procedure describes how create a dataflow that merges duplicate records into a best of breed record.
You now have a dataflow that identifies matching records and merges records within a collection into a single best of breed record.