Decision Transformation Overview
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.