Learning Informatica PowerCenter 10.x - Second Edition

Optimizing the database query

When you read the data from the database table, the integration service generates a query to extract the data from the table. You can fine-tune the query to extract only the required data. If you extract all the data and then add filter or other transformations, it will hamper the performance. You can tune the query to extract only the required data, which will save time and help in performance enhancement. This is called SQL override.

These were the various ways in which you can find and eliminate the source bottleneck. In the next section, we will talk about the mapping and transformation bottleneck.