Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

Binding Mapping Outputs to Workflow Variables

Binding Mapping Outputs to Workflow Variables

You can bind mapping outputs to workflow variables and pass the values to other tasks in the workflow.
To pass the mapping output value to another task, bind the mapping output to a workflow variable in the Mapping task
Output
view. You can bind mapping outputs from the current Mapping task or you can bind the persisted mapping outputs from the previous Mapping task run.
  1. Add the mapping with the mapping outputs to a workflow.
  2. Click the Mapping task icon in the workflow to view the Mapping task
    Properties
    .
  3. In the Mapping task
    Properties
    , click the
    Output
    view.
    The Mapping task
    Output
    view shows the data that you can pass from the task into workflow variables.
  4. Find the mapping output that you want to bind to a variable.
  5. Double-click the
    Variable
    column to access the selection arrow and view a list of workflow variables.
    The following image shows where to bind the Total_Order_Amt mapping output to the wf_Variable_Total_OrderAmt workflow variable in the Mapping task
    Output
    view:
    The Output view shows System-Defined Mapping outputs, and User-Defined Mapping outputs that you can assign to workflow variables. The Total Order Amount mapping output is assigned to wf_Variable_Total_OrderAmt workflow variable.
  6. To create a workflow variable, click the
    New Variable
    option from the list of workflow variables in the
    Value
    column.
    Enter the variable name, type, and default value.

0 COMMENTS

We’d like to hear from you!