Standing at the last chapter, you must be very clear with all the components and features of the Informatica tool. As with any other technology related to data, we need to understand the performance tuning of Informatica as well. It is necessary to follow the best practices to achieve the best performance out of your code. Similar to SQL tuning, which is done to enhance the performance of SQL query, we do performance tuning on Informatica. If you follow the best practices of Informatica, your code will be automatically tuned. There are many best practices that are recommended by Informatica-many of which we have already discussed in previous chapters. We will be talking about those best practices under this chapter as well to understand how to use them in order to achieve better performance.
When we talk about performance tuning, you need to find out the issues in your code called bottlenecks. The regular process is to first find out the bottlenecks...