Increasing the number of processing threads increases the load on the nodes that run mappings. If the nodes contain ample CPU bandwidth, concurrently processing rows of data in a mapping can optimize mapping performance.
The Data Integration Service can use multiple CPUs to process a mapping that contains multiple partitions. The number of CPUs that the service uses depends on factors such as the number of partition points, the number of threads created for each pipeline stage, and the amount of resources required to process the mapping. A simple mapping runs faster in two partitions, but typically requires twice the amount of CPU than when the mapping runs in a single partition.