Bulk Data Movement Guide

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

Back Next

Reading Data into the First Reader Partition Only

Complete the following steps to read data only into the first reader partition. This partitioning scheme applies to nonrelational data sources for which you do not use offload processing. You can redistribute rows from the reader partition across subsequent partitions to increase the speed of session processing.

You must use pass-through partitioning without SQL overrides. To redistribute rows from the first reader partition in subsequent partitions, add a round-robin partition point immediately after the reader partition.

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

Edit Tasks

dialog box.

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 an identical query for each partition, perform the following steps for each partition:

In the

SQL Query

field, click the Browse button.

Clear the query in the

SQL Editor

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

Click

On the

Mapping

tab, click the

Partitions

view.

To redistribute rows from the first reader partition across subsequent partitions, complete the following substeps:

Click the

Add Partition Point

icon to add a partition point after the Source Qualifier transformation.

Click

Edit Partition Point

Select

Round Robin

in the

Partition Type

list, and click

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

Reading Data into the First Reader Partition Only

Reading Data into the First Reader Partition Only