Informatica Operator Precedence

Informatica Operator Precedence

The transformation language supports the use of multiple operators and the use of operators within nested expressions.

If you write an expression that includes multiple operators, the PowerCenter Integration Service evaluates the expression in the following order:

1. Arithmetic operators
2. String operators
3. Comparison operators
4. Logical operators

The PowerCenter Integration Service evaluates operators in the order they appear in the following table. It evaluates operators in an expression with equal precedence to all operators from left to right.

The following table lists the precedence for all transformation language operators:

Operator

Meaning

(  ) Parentheses.
+, -, NOT Unary plus and minus and the logical NOT operator.
*, /,% Multiplication, division, modulus.
+, – Addition, subtraction.
|| Concatenate.
<, <=, >, >= Less than, less than or equal to, greater than, greater than or equal to.
=, <>, !=, ^= Equal to, not equal to, not equal to, not equal to.
AND Logical AND operator, used when specifying conditions.
OR Logical OR operator, used when specifying conditions.

 

The transformation language also supports the use of operators within nested expressions. When expressions contain parentheses, the PowerCenter Integration Service evaluates operations inside parentheses before operations outside parentheses. Operations in the innermost parentheses are evaluated first.

For example, depending on how you nest the operations, the equation 8 + 5 – 2 * 8 returns different values:

Equation

Return Value

8 + 5 – 2 * 8 -3
8 + (5 – 2) * 8 32
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s