Its been some time since the last post, but now i am back with a pretty interesting article Performance tuning is a very vital aspect in any project. The faster and better interface is always appreciated and wins laurels When the file size/ table which act as our sources are huge in size and the throughput is very low then we can go for partitioning. In partitioning we can split the data into various threads so data will be processed faster If the informatica we are using is a standard edition then partitioning feature will not be available so now what we can do is increase DTM buffer size. It will be present in session properties under performance section. By default it will be in auto mode we can change it to say 220mb,1gb etc depending on size of the source data.This will increase the throughput If the lookup transformation is taking is long time than we can go for joiner transformation to perform the same operation. As joiner will be better in performance when com