This section describes the new features in the Expression transformation.
Effective in version 10.0, you can create an expression in a dynamic output port. When you create an expression in a dynamic port, the expression is a dynamic expression. A dynamic expression might generate more than one output port when the expression contains a port selector or a dynamic port. When the dynamic expression runs against multiple ports, the expression returns an output value for each port.
For more information about dynamic expressions, see the
chapter in the
Informatica 10.0 Developer Transformation Guide
Effective in version 10.0, you can configure mapping outputs. A mapping output is a single value that is the result of aggregating a field or expression from each row that the mapping processes. For example, a mapping output can summarize the total amount of an order field from all the source rows that the transformation receives. A mapping output expression is a field value or an expression to aggregate from the rows that the Expression transformation receives. You must define a mapping output in the mapping
view, before you can create the corresponding expression in the Expression transformation.
For more information about mapping outputs, see the
chapter in the
Informatica 10.0 Developer Mapping Guide
Effective in version 10.0, you can test expressions that you configure in the Expression Editor. When you test an expression, you enter sample data and then evaluate the expression.
You can test expressions when you configure expressions in the following ways:
In an output or variable port in the Expression transformation
In the Mapping Outputs view of an Expression transformation after adding the transformation to a mapping
The following image shows the results of an expression that concatenates a sample first name and last name:
For more information about testing expressions, see the "Expression Transformation" chapter in the