When you configure key range partitioning for a Db2 Warehouse Source Qualifier transformation, the PowerCenter Integration Service distributes rows of data based on a port or set of ports that you define as the partition key. You can define a range of values for each port. The PowerCenter Integration Service uses the key and ranges to send rows to the appropriate partition. You can specify SQL query and source filter conditions in the Db2 Warehouse session properties to override the SQL query and source filter condition that you specified in the source qualifier. The PowerCenter Integration Service uses the SQL query and source filter condition you specify in the session properties when it reads data from the source.

To configure key range partitioning, select the Source Qualifier transformation, and add a partition point from the

Mapping

tab of the session properties. Add the number of partitions you require and select the partition type as

Key Range

for each of the partitions.

Based on the number or partitions you add, the PowerCenter Integration Service adds those many number of partition fields for the

Filter Override

attribute in the session properties. Specify the SQL query and source filter for each of the partitions. The PowerCenter Integration Service uses the SQL query and source filter conditions you specify to pass data through the appropriate partition.