Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Expression Transformation

Expression Transformation

This section describes the new features in the Expression transformation.
Dynamic Expressions
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
Expression Transformations
chapter in the
Informatica 10.0 Developer Transformation Guide
.
Mapping Outputs
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
Properties
view, before you can create the corresponding expression in the Expression transformation.
For more information about mapping outputs, see the
Mapping Outputs
chapter in the
Informatica 10.0 Developer Mapping Guide
.
Test Expressions
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:
In the testing panel, "John" is the test value for the FirstName field and "Baer" is the test value for the LastName field. The result of the expression is "John Baer."
For more information about testing expressions, see the "Expression Transformation" chapter in the
Informatica 10.0 Developer Transformation Guide
.


Updated September 25, 2020