Database Reference
In-Depth Information
Chapter 9. Optimization - Performance
Tuning
Having reached the last chapter, you must be very clear about all the components and fea-
tures of the Informatica tool. As with any other technology related to data, we need to un-
derstand the performance tuning of Informatica. It is necessary to follow the best practices
to achieve the best performance of your code. We execute performance tuning on Informat-
ica similar to SQL tuning, which is done to enhance the performance of SQL queries. If
you follow the best practices of Informatica, your code will be tuned automatically. There
are various best practices that are recommended by Informatica, many of which we have
already discussed in the previous chapters. We will be talking about these best practices in
this chapter as well in order to understand how to use them to achieve better performance.
When we talk about performance tuning, you need to find out the issues in your code,
which are called bottlenecks. The regular process is to first find out the bottlenecks and
then eliminate them to enhance the performance.
We will discuss the various components that need to be tuned in order to enhance the pro-
cess. In the next section, we will talk about how to identify the bottlenecks at various com-
ponents, and we will also talk about how to eliminate them.
Search WWH ::




Custom Search