Performance Tuning (Informatica)

1. Filter rows at source qualifier
2. Sort data at source qualifier, whenever needed, instead of using sorter
3. Use filter transformations as close to the source as possible
4. Use sorted input for aggregator
5. Use database partitioning
6. Use workflow partitioning
7. Avoid multiple datatype conversions
8. Use variables for repetitive calculations
9. Avoid joiners
10. Use sorted input for joiner
11. In joiners, use the sources with less data as master
12. From source qualifier, take out only those ports which are required
13. In lookup, delete the ports from the tranformations, which are not required