Developer Mapping Guide

10.2.2
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.1

Back Next

Configuring Pushdown

You can configure a mapping for pushdown optimization in the mapping run-time properties.

Open a mapping.

On the

Properties

tab, select

Run-time

Choose a pushdown type or assign a pushdown parameter:

None

. The Data Integration Service does not pushdown the mapping logic to the source database.

Full

. The Data Integration Service pushes down the full mapping logic to the source database.

Source

. The Data Integration Service pushes down all mapping logic except the target to the source database.

Assign Parameter

. Select the parameter that you configured for pushdown type or create a new parameter and click

Optionally, if you choose full pushdown optimization and the mapping contains an Update Strategy transformation, you can choose a pushdown compatibility option or assign a pushdown compatibility parameter.

Multiple rows do not have the same key.

The target transformation connected to the Update Strategy transformation receives multiple rows that have the same key. The Data Integration Service can pushdown the Update Strategy transformation.

Multiple rows with the same key can be reordered.

The target transformation connected to the Update Strategy transformation receives multiple rows with the same key that can be reordered. The Data Integration Service can pushdown the Update Strategy transformation.

Multiple rows with the same key cannot be reordered.

The target transformation connected to the Update Strategy transformation receives multiple rows with the same key that cannot be reordered. The Data Integration Service cannot pushdown the Update Strategy transformation.

Assign Parameter

. Select the parameter that you configured for pushdown compatibility or create a parameter and click

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Configuring Pushdown

Configuring Pushdown