Bulk Data Movement Guide

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

Back Next

Setting Up Pass-Through Partitioning with SQL Overrides for Nonrelational Data Sources

Complete the following steps to set up pass-through partitioning with SQL overrides for nonrelational data sources for which you do not use offload processing.

The partitions run independently of each other and treat each query as an independent PowerExchange request.

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

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.

For each partition, click the Browse button in the

SQL Query

field. Then, in the

SQL Editor

dialog box, enter the query and click

If you entered a query in Designer when you configured the Source Qualifier transformation, the query appears in the

SQL Query

field for each partition. To override this query, enter another query in the

SQL Editor

dialog box.

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 with SQL Overrides for Nonrelational Data Sources

Setting Up Pass-Through Partitioning with SQL Overrides for Nonrelational Data Sources