Informatica – Session Performance

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.