Specifies the number of threads that the Data Integration Service tries to create for the current transformation at run time. The Data Integration Service considers the Execution Instances value if you override the Maximum Parallelism run-time property on the mapping that contains the transformation. The default Execution Instances value is Auto.

The Data Integration Service considers multiple factors to determine the number of threads to assign to the transformation. The principal factors are the Execution Instances value and the values on the mapping and on the associated application services in the domain.

The Data Integration Service that runs the mapping reads the following values to determine the number of threads to use for the transformation:

The
Maximum Parallelism
value on the Data Integration Service. Default is 1.
Any
Maximum Parallelism
value that you set at the mapping level. Default is Auto.
The
Execution Instances
value on the transformation. Default is Auto.

If you override the Maximum Parallelism value at the mapping level, the Data Integration Service attempts to use the lowest value across the properties to determine the number of threads.

If you use the default Maximum Parallelism value at the mapping level, the Data Integration Service ignores the Execution Instances value.

Consider the following rules and guidelines when you set the number of execution instances:

Multiple users might run concurrent mappings on a Data Integration Service. To calculate the correct number of threads, divide the number of central processing units that the Data Integration Service can access by the number of concurrent mappings.
When you use the default Execution Instances value and the default Maximum Parallelism values, the transformation operations are not partitionable.

Determines whether the transformation applies the comparison algorithm in a match strategy to pairs of identical records in the input data.

When the transformation finds a pair of identical records, the algorithm does not need to analyze the levels of similarity between the records. The transformation can pass the records directly to the output stage without additional analysis. To configure the transformation to pass the identical records directly to the output stage, select Filter Exact Match. When the input data contains many identical rows, the comparison algorithm performs fewer calculations, and the mapping runs faster.

Select the option when the input data contains many identical rows. Do not select the option if the input data does not contain many identical rows, as the transformation might run more slowly.

Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.