Bottlenecks

As mentioned, we can have bottlenecks at various stages of the Informatica PowerCenter code. Don't be in a rush to find all the bottlenecks and eliminate them together. Try to find the first bottleneck, resolve it, and then jump to another.

Finding the target bottleneck

Always consider checking the bottlenecks at the target side first. There can be various reasons for bottlenecks at the target. First, we need to know how to find the target bottleneck.

Using thread statistics

Thread statistics are a part of the session log. When you run the workflow, the...