When you specify pass-through partitioning for a PostgreSQL Source Qualifier transformation, you can specify filter conditions in the PostgreSQL session properties to override the filter condition you specify in the source qualifier. The Integration Service uses the filter condition you specify in the session properties when it filters data from the source.

To configure pass-through 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 pass through 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 filter override condition for each of the partitions. The PowerCenter Integration Service uses the filter conditions you specify to pass data through the appropriate partition.

Similarly, you can specify the fetch size for each of the partitions in the PostgreSQL source session properties.