Add one partition at a time.

To best monitor performance, add one partition at a time, and note the session settings before you add each partition.

Set DTM Buffer Memory.

When you increase the number of partitions, increase the DTM buffer size. If the session contains

n

partitions, increase the DTM buffer size to at least n times the value for the session with one partition.

Set cached values for Sequence Generator.

If a session has

n

partitions, you should not need to use the “Number of Cached Values” property for the Sequence Generator transformation. If you set this value to a value greater than 0, make sure it is at least

n

times the original value for the session with one partition.

Partition the source data evenly.

Configure each partition to extract the same number of rows.

Monitor the system while running the session.

If CPU cycles are available, you can add a partition to improve performance. For example, you may have CPU cycles available if the system has 20 percent idle time.

Monitor the system after adding a partition.

If the CPU utilization does not go up, the wait for I/O time goes up, or the total data transformation rate goes down, then there is probably a hardware or software bottleneck. If the wait for I/O time goes up by a significant amount, then check the system for hardware bottlenecks. Otherwise, check the database configuration.