Based on number of partitions.

Sets the partitions to a number that you define in the

Number of Partitions

attribute. Use the

$DynamicPartitionCount

session parameter, or enter a number greater than 1.

Based on number of nodes in grid.

Sets the partitions to the number of nodes in the grid running the session. If you configure this option for sessions that do not run on a grid, the session runs in one partition and logs a message in the session log.

Based on source partitioning.

Determines the number of partitions using database partition information. The number of partitions is the maximum of the number of partitions at the source. For Oracle sources that use composite partitioning, the number of partitions is the maximum of the number of subpartitions at the source.

Based on number of CPUs.

Sets the number of partitions equal to the number of CPUs on the node that prepares the session. If the session is configured to run on a grid, dynamic partitioning sets the number of partitions equal to the number of CPUs on the node that prepares the session multiplied by the number of nodes in the grid.