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 Read Data from a SAS Source

You can configure a pass-through partitioning to read data from a SAS source.

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 data to a flat file.

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

Merge Type

property to

No merge

When the

Merge Type

option is

No merge

, the Integration Service creates partition files equivalent to the number of partitions with equally distributed records.

The following image shows the configured

No merge

option in the target session properties:

If you set a different option for the

Merge Type

in the target session properties, the Data Integration Service creates a single target file that contains all the records read through the partitions.

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 Read Data from a SAS Source

Configuring Pass-Through Partitioning to Read Data from a SAS Source