PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

Configuring Partitioning

When you create or edit a session, you can add partition to the sources to improve the session performance.

Perform the following steps to configure partitioning:

In the Workflow Manager, open the session.

Double-click the session.

The

Session Properties

dialog box appears.

Click

Mapping

The

Mapping

tab appears.

Click

Partitions

and select the partition point where you want to add the partition.

Click

Edit Partition Point

The

Edit Partition Point

dialog box appears.

Click

Add

to add a partition.

You can add multiple partitions as required.

The following image shows the

Edit Partition Point

dialog box where you can add partitions: You can add partitions in the Edit Partion Point dialog box.

Under the

Partition Type

section, select the

Pass Through

partition.

Click

The

Edit Partition Point

dialog box closes.

In the

Properties

section on the

Mapping

tab, navigate to the

INFA ADVANCED FILTER

attribute.

Add the filter conditions for each partition to optimize the search.

For example,

id>0 AND id<1000

The following image shows the

INFA ADVANCED FILTER

attribute where you can add the filter conditions:

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide for PowerCenter

PowerExchange for Amazon Redshift User Guide for PowerCenter

Configuring Partitioning

Configuring Partitioning