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. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Mapping Output Expression

Mapping Output Expression

Configure a mapping output expression in the
Mapping Outputs
view of an Expression transformation. The mapping output expression is a field or an expression to aggregate from the rows that the Expression transformation receives.
Configure an Expression transformation in the mapping and include the output expressions that you want to aggregate. The location of the Expression transformation in the pipeline might affect the mapping output results depending on whether the mapping contains filters or active transformations. You can add more than one Expression transformation to the mapping if you need to aggregate rows in different pipelines.
The following image shows the expressions in the
Mapping Outputs
view of the Expression transformation:
The image shows the focus on an Expression transformation in the mapping. The Mapping Outputs view on the Properties tab hows two entries, the Total Order Amount expression is Order Amount plus Order Amount * .0875. The Last Order Data expression contains the port name OrderDate.
The
Mapping Outputs
view has the following fields:
Outputs Name
The name of a mapping output that you created at the mapping level. You must create the mapping output at the mapping level first. When you add the mapping output in the Expression transformation, you select the output name from a list of the outputs that you have already created.
Expression
The expression to aggregate for each row in the mapping. Enter a port name or enter an expression in the Expression Editor. The expression result must be numeric or a date. You can use parameters in the expression. The Data Integration Service applies the expression for each row that the Expression transformation receives. Each mapping output returns one value when the mapping completes.
You do not specify the type of aggregation to perform in the Expression transformation. You indicate the field or expression that the mapping aggregates as it processes each row.

0 COMMENTS

We’d like to hear from you!