The Decision transformation is a passive transformation that evaluates conditions in input data and creates output based on the results of those conditions.
Configure a Decision transformation to generate different values based on the values found in input fields. For example, if customer revenue is greater than a specific amount, you can add the string "Priority" to the customer name.
You can add multiple decision strategies to the Decision transformation. Each strategy evaluates an
IF-THEN-ELSE
conditional statement. Within this statement, you can use
ELSEIF
conditions or nest additional
IF-THEN-ELSE
statements.
The Decision transformation is similar to the Expression transformation in that it allows you to use conditional statements and functions to test source data. However, the Decision transformation is different from the Expression transformation in the following ways:
The Decision transformation uses
IF-THEN-ELSE
statements to evaluate conditions. The Expression transformation uses
IIF
statements.
The Decision transformation contains functions that are not available in the Expression transformation.
Each decision strategy can generate multiple outputs.