Increasing Informatica Server Performance

There are many factors that can affect session performance. Here are some of the reasons. Before doing tuning that is specific to Informatica: 1. Slow disk access on source and target databases, source and target file systems, as well as the Informatica Server and repository machines can slow session performance.So check hard disks on related machines. 2. Slow network connections can slow session performance.Therefore Improve network speed. 3. Check the Informatica Server and related machines run on high performance CPUs.Check CPUs on related machines. 4. Configure physical memory for the Informatica Server to minimize disk I/O. (Configure the physical memory for the Informatica Server machine to minimize paging to disk.) 5. Optimize database configuration 6. Staging areas. If you use a staging area, you force the Informatica Server to perform multiple passes on your data. Where possible, remove staging areas to improve performance. 7. You can run multiple Informatica Servers on separate systems against the same repository. Distributing the session load to separate Informatica Server systems increases performance. Informatica specific: - Transformation tuning - Using Caches - Avoiding Lookups by using DECODE for smaller and frequently used tables - Applying Filter at the earliest point in the data flow etc.