Developer Transformation Guide

Back Next

Decision Transformation Advanced Properties

Configure properties that help determine how the Data Integration Service processes data for the Decision transformation.

Configure the following advanced properties for a Decision transformation:

Tracing Level: Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Partitionable: The transformation can be processed with multiple threads. Clear this option if you want the Data Integration Service to use one thread to process the transformation. The Data Integration Service can use multiple threads to process the remaining mapping pipeline stages.

You might want to disable partitioning for a Decision transformation when the transformation uses one of the numeric functions CUME, MOVINGSUM, or MOVINGAVG. These functions calculate running totals and averages on a row-by-row basis. A partitioned transformation that uses CUME, MOVINGSUM, or MOVINGAVG functions might not return the same calculated result with each mapping run.

If the transformation does not use CUME, MOVINGSUM, or MOVINGAVG functions, enable partitioning for the transformation to optimize performance.