If the volume of data grows or you add more processors, you can adjust partitioning so that the run time does not increase. When you use dynamic partitioning, you can configure the partition information so that the Data Integration Service determines the number of partitions to create at run time.
Some transformations do not support partitioning. When a mapping enabled for partitioning contains a transformation that does not support partitioning, the Data Integration Service uses one thread to run the transformation. The Data Integration Service can use multiple threads to run the remaining mapping pipeline stages.
You can optimize write performance by using dynamic partitioning.