Logical Operators
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, Informatica Cloud produces the following results:
- •NULL AND TRUE = NULL
- •NULL AND FALSE = FALSE