Developer Mapping Guide

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

Back Next

Optimizer Levels

The Data Integration Service optimizes mappings based on the optimizer level that you configure. Configure the optimizer level when you want the mapping to use an optimizer level other than the normal. By default, each mapping uses the normal optimizer level.

You can choose one of the following optimizer levels:

None: The Data Integration Service does not apply any optimization.
Minimal: The Data Integration Service applies the early projection optimization method.
Normal: The Data Integration Service applies the early projection, early selection, branch pruning, push-into, global predicate optimization, and predicate optimization methods. Normal is the default optimization level.
Full: The Data Integration Service applies the cost-based, early projection, early selection, branch pruning, predicate, push-into, semi-join, and dataship-join optimization methods.

The Data Integration Service applies the normal optimizer level when you run a mapping from the

Run

menu or mapping editor in the Developer tool. When you run the mapping from the

Run

menu, the Data Integration Service applies the optimizer level in the mapping configuration. When you run the mapping from the command line, the Data Integration Service applies the optimization level from the mapping deployment properties in the application.

The Data Integration Service does not apply the pushdown optimization method with an optimizer level. You can configure pushdown optimization for a mapping in the mapping run-time properties.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Optimizer Levels

Optimizer Levels