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 session log generates the thread statistics, which can provide you with information about the bottlenecks present in Source, Target, or Transformation. Thread statistics give information about the total runtime, idle time, and busy percentage of Source, Target, and Transformation.
Thread statistics consist of Reader thread, Writer thread, and Transformation thread. Reader thread gives information related to the total runtime, idle...
