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..
Keep Reading
