PowerExchange for SAS User Guide for PowerCenter

10.5.8
- 10.5.9
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Configuring Pass-Through Partitioning to Write Data to a SAS Target

You can configure a pass-through partitioning to write data to a SAS target.

Perform the following steps if you want to configure pass-through partitioning for a session configured to read data from a SAS source and write the data to a SAS target.

Start the PowerCenter Designer and connect to a PowerCenter repository configured with a SAS instance.

Click

Sources

in the Source Analyzer and choose

Import SAS Source

This option is not available for SAS sources imported from a SAS file.

Click

Targets

in the Target Designer and import a flat file target.

In the Mapping Designer, create a mapping to read data from the SAS source and write to a flat file.

Validate the mapping.

In the Workflow Designer, open the session properties.

On the

Partitions

view, click

Add Partition Point

Select the Source transformation, and click

Edit Partition Point

The Edit Partition Point dialog box appears.

Click

Add

to add the required number of partitions and enter a description for each partition.

Select the partition type as

Pass Through

for each of the partitions.

The following image shows the configured pass-though partitioning for a SAS session:

In the target session properties, you can set the

Output Per Partition

property as

Yes

When the

Output Per Partition

option is

Yes

, the Integration Service creates SAS targets equivalent to the number of partitions with equally distributed records.

The following image shows the configured

Output Per Partition

option in the target session properties:

Rename Saved Search

Table of Contents

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Configuring Pass-Through Partitioning to Write Data to a SAS Target

Configuring Pass-Through Partitioning to Write Data to a SAS Target