Bulk Data Movement Guide

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Setting Up Pass-Through Partitioning Without SQL Overrides for Data Sources

Complete the following steps to set up pass-through partitioning without SQL overrides if you use the following data sources with offload processing: DB2 for z/OS unload data sets, VSAM data sets, and sequential files.

PowerExchange reads the source data once and automatically distributes the rows across the partitions.

In the Workflow Manager, open a PWX application connection by completing the following steps:

Click

Connections

Application

The

Application Connection Browser

dialog box appears.

In the

Select Type

field, select

PWX NRDB Batch

Select a connection object the

Objects

list and click

Edit

. Or click

New

to create a connection.

In the

Connection Object Definition

dialog box, select one of the following options from the

Offload Processing

list:

Filter Before

. PowerExchange offloads column-level processing to the PowerCenter Integration Service machine but continues to filter data on the source system.

Filter After

. PowerExchange offloads column-level processing and data filtering to the PowerCenter Integration Service machine.

Click

In the Task Developer, double-click the session to open the

Edit Tasks

dialog box.

On the

Properties

tab, select one of the following options for the

PWX Partition Strategy

attribute:

Single Connection

. PowerExchange creates a single connection to the data source. Any overrides specified for the first partition are used for all partitions. If you specify any overrides for other partitions that are different from the overrides for the first partition, the session fails with an error message.

Overrides Driven

. If the specified overrides are the same for all partitions, PowerExchange creates a single connection to the data source. If the overrides are not identical for all partitions, PowerExchange creates multiple connections.

On the

Mapping

tab, click the

Partitions

view.

Select the Source Qualifier transformation, and click

Edit Partition Point

The

Edit Partition Point

dialog box appears.

Click

Add

for each partition that you want to add.

Verify that the

Partition Type

Pass Through

Click

On the

Mapping

tab, click the

Transformations

view.

The

Properties

area displays the

SQL Query

attribute for each partition.

Verify that the

SQL Query

attribute is empty or contains an identical query for each partition.

If the

SQL Query

attribute is not empty and does not contain identical queries, perform the following steps for each partition:

Click the Browse button in the

SQL Query

attribute.

Clear the query in the

SQL Editor

dialog box, or enter the same query for each partition.

Click

Reader Partitioning

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Setting Up Pass-Through Partitioning Without SQL Overrides for Data Sources

Setting Up Pass-Through Partitioning Without SQL Overrides for Data Sources