If the volume of data grows or you add more processors, you might need to 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.
The Data Integration Service scales the number of partitions at run time based on factors such as source database partitions or the number of nodes in a grid.
If any transformation in a stage does not support partitioning, or if the partition configuration does not support dynamic partitioning, the Data Integration Service does not scale partitions in the pipeline. The data passes through one partition.
You can optimize read performance by using key range partitioning and optimize write performance by using dynamic partitioning.