Cloud Data Integration for PowerCenter
- Cloud Data Integration for PowerCenter
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Operator Type | Operator | Description |
|---|---|---|
Assignment | := | Assigns a value to a port. |
Boolean | AND | Adds a required logical condition. For the parent Boolean expression to be true, all logical conditions linked by this operator must be true. |
Boolean | OR | Adds a logical condition. For the parent Boolean expression to be true, at least one logical condition linked by this operator must be true. |
Boolean | NOT | Specifies a negative logical condition. For the parent Boolean expression to be true, the negative condition specified by this operator must be true. |
Decision | = | Tests whether compared items are equal. Use with string or numeric datatypes. |
Decision | <> | Tests whether compared items are not equal. Use with string or numeric datatypes. |
Decision | < | Tests whether a value is less than another value. Use with numeric datatypes. |
Decision | <= | Tests whether a value is less than or equal to another value. Use with numeric datatypes. |
Decision | > | Tests whether a value is greater than another value. Use with numeric datatypes. |
Decision | >= | Tests whether a value is greater than or equal to another value. Use with numeric datatypes. |
Numerical | - | Subtraction |
Numerical | NEG | Negation |
Numerical | + | Addition |
Numerical | * | Multiplication |
Numerical | / | Division |
Numerical | % | Modulo. Returns the remainder after dividing one number by another. |
String | || | Concatenates strings. |
