PowerExchange for JDBC V2 User Guide

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5
- 10.4.0

Back Next

Partitioning

When you configure a JDBC V2 mapping to read data from the database that supports the Type 4 JDBC driver, you can configure partitioning to optimize the mapping performance at run time. The partition type controls how the Data Integration Service distributes data among partitions at partition points.

The following table summarizes the partition type options that you can configure for a read or write operation on the native and non-native environments:

Operation Type	Supported Partition Type in Native Environment	Supported Partition Type in Non-Native Environment
Read	You can select from the following partition types: None . By default, the Data Integration Service creates a single partition. Key Range . The Data Integration Service distributes rows of data based on a port or set of ports that you define as the partition key. The default number of partitions is 2.	You can select from the following partition types: None . By default, the Data Integration Service creates a single partition. Fixed . Define partition key for at least one column.
Write	None . By default, the Data Integration Service creates a single partition. Dynamic . By default, the Data Integration Service creates the same number of partitions for the target based on the number of partitions you specified for the source.	None . By default, the Data Integration Service creates a single partition. Fixed . Define partition key for at least one column. Dynamic . By default, the Data Integration Service creates the same number of partitions for the target based on the number of partitions you specified for the source.