Test mapping performance using a flat file target and use thread statistics to identify a target bottleneck.
To identify a target bottleneck, complete the following tasks:
•Configure a copy of the mapping to write to a flat file target. If the performance increases significantly, you have a target bottleneck. If a mapping already writes to a flat file target, you probably don't have a target bottleneck.
•Read the thread statistics in the session log. When the mapping task spends more time on the writer thread than the transformation or reader threads, you have a target bottleneck.