Optimizing informatica is a challenging task. Sr Developers work on it.

There are various methods we can improve performance:

1) We need to use Grid to increase session and wf performance

2) Use push down optimization. IS will run SQL query either in Source/Target

3) Run session/wf concurrently

4) Increase DTM buffer size, Optimize buffer block size

5) Increase cache size etc..

Advertisements