Database Reference
In-Depth Information
Finding the mapping bottleneck
If you don't have a source or target bottleneck, you might have a mapping or transforma-
tions bottleneck.
Using thread statistics
As discussed in the
Finding the target bottleneck
section, use thread statistics to find the
transformation bottleneck. Refer to this section to use thread statistics.
Using a Filter transformation
You can use a Filter transformation to check whether the transformation in the mapping is
causing a bottleneck. Put a Filter transformation before the target and set the condition to
False
, that is, don't allow any record to pass to the target. Using this method, you can com-
pare the runtime of the process with and without the filter condition. This way, you can
identify whether the transformations have a bottleneck.
