To tune the performance of a mapping, first identify a performance bottleneck, eliminate it, and then identify the next performance bottleneck until you are satisfied with the performance.

Determining the best way to improve performance is an iterative process. Change one variable at a time, and time the mapping both before and after the change. If the mapping performance doesn't improve, you might want to return to the original configuration.

Performance issues can occur for any of the following reasons:

Best practices not followed
Target bottlenecks
Source bottlenecks
Transformation bottlenecks
System bottlenecks