Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Example. Expression Parameters in an Expression Transformation

Example. Expression Parameters in an Expression Transformation

Use an expression parameter to parameterize the port expression in an Expression transformation.
For example, you might want to use an Expression transformation to concatenate data on states and cities.
The following table lists the data that you might transform:
State
City
CA
Sacramento
TX
Austin
NY
Albany
You want to concatenate the data using the expression
CONCAT(CONCAT(City, ','),State)
. In the Expression transformation, configure an output port
Location
and assign an expression parameter to the port expression.
The following image shows the output port
Location
in the Expression transformation:
This image shows the Ports tab in an Expression transformation. The Ports tab has three ports, two input ports and one output port. The two input ports are State and City. The output port is Location.
The following image shows where you can configure the new expression parameter:
This image shows the New Parameter dialog box and the Expression Editor where you can configure the expression for the parameter.
The following image shows where the expression parameter appears:
This image shows the Ports tab of the Expression transformation. The port expression for the output port Location shows the expression parameter.
When you run the mapping, the output port uses the expression parameter to write data using the format
City,State
, such as
Sacramento,CA
.

0 COMMENTS

We’d like to hear from you!