ToM Report Series on Data Warehouse – Removing duplicates using Informatica Powercenter
There is more than one way to skin a cat, and there are four ways to choose one distinct row of several possibilities in an Informatica PowerCenter mapping; Rank, Sort, Aggregate and the sorted Expression-filter technique. Each method has its own pros and cons, and a good developer should know when to use which technique. This white paper detail four different methods and discuss when each one of them should be used. Ideally, you want to have more than one possible solution for each scenario you encounter, and determine which ultimate technique to use by comparing run time, memory usage and other parameters of importance to your configuration.