PowerCenter - Expressions

Card Puncher Data Processing

About

Page about Expression in Powercenter. The expression are build with the expression editor.

Operator

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





Discover More
Powercenter Designer Tools
PowerCenter - Designer

The Designer has the following tools that you use to analyze sources, design target schemas, and build source-to-target mappings: . Import or create source definitions. . Import or create target definitions....
Powercenter Pre Session Variable Assignment
PowerCenter - Mapping (Parameter|Variable)

When you use a mapping parameter or variable in a mapping, first you declare the mapping parameter or variable for use in each mapplet or mapping. Then, you define a value for the mapping parameter or...
Powercenter Port
PowerCenter - Port

Data passes into and out of a mapping through the following ports: Input ports. Receive data. Output ports. Pass data. Input/output ports. Receive data and pass it unchanged. A set of ports...
Powercenter Designer Tools
PowerCenter - Transformation Developer

PowerCenter Transformation Developer is a component/tool of designer. Its aim is to develop transformation to use in a mapping. You can also develop user-defined functions to use in .
Powercenter Transformation Create
PowerCenter - Transformations

A transformation is a part of a mapping that generates or modifies data. Every mapping includes a Source Qualifier transformation, representing all data read from a source and temporarily stored by the...



Share this page:
Follow us:
Task Runner