All transformations have some basic counters that indicate the number of input rows, output rows, and error rows.

Source Qualifier, Normalizer, and target transformations have additional counters that indicate the efficiency of data moving into and out of buffers. Use these counters to locate performance bottlenecks.

Some transformations have counters specific to their functionality. For example, each Lookup transformation has a counter that indicates the number of rows stored in the lookup cache.

When you view the performance details file, the first column displays the transformation name as it appears in the mapping, the second column contains the counter name, and the third column holds the resulting number or efficiency percentage. If you use a Joiner transformation, the first column shows two instances of the Joiner transformation:

When you create multiple partitions, the Integration Service generates one set of counters for each partition. The following performance counters illustrate two partitions for an Expression transformation:

The following table describes the Aggegator and Rank Transformation counters/descriptions that may appear in the Session Performance Details area or in the performance details file:

The following table describes the Lookup Transformation counters/descriptions that may appear in the Session Performance Details area or in the performance details file:

The following table describes the Master and Detail Joiner Transformation counters/descriptions that may appear in the Session Performance Details area or in the performance details file:

The following table describes All Other Transformation counters/descriptions that may appear in the Session Performance Details area or in the performance details file:

If you have multiple source qualifiers and targets, evaluate them as a whole. For source qualifiers and targets, a high value is considered 80-100 percent. Low is considered 0-20 percent.