Use logical operators to manipulate numeric data. Expressions that return a numeric value evaluate to TRUE for values other than 0, FALSE for 0, and NULL for NULL.
The following table lists the transformation language logical operators:
Operator
Meaning
NOT
Negates result of an expression. For example, if an expression evaluates to TRUE, the operator NOT returns FALSE. If an expression evaluates to FALSE, NOT returns TRUE.
AND
Joins two conditions and returns TRUE if both conditions evaluate to TRUE. Returns FALSE if one condition is not true.
OR
Connects two conditions and returns TRUE if any condition evaluates to TRUE. Returns FALSE if both conditions are not true.
Nulls
Expressions that combine a null value with a Boolean expression produce results that are ANSI compliant.
For example, Data Integration produces the following results: