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

Assigning Persisted Outputs to Mapping Task Input

Assigning Persisted Outputs to Mapping Task Input

You can bind persisted mapping outputs from a Mapping task to the input parameters of the same Mapping task for the next time the workflow runs.
Assign the persisted latest order date value from the Mapping task as the input parameter to the same Mapping task. Configure a Filter transformation that uses a Last_OrderDate_Parm parameter to select which orders to process. The filter expression to select input rows is
Order_Date > Last_OrderDate_Parm
.
  1. Click the Mapping task icon in the workflow to view the Mapping task
    Properties
    view.
    A list of the Mapping task input parameters and a list of the parameterized Mapping task configuration properties appears. The mapping must have a mapping parameter to assign the mapping output to.
  2. Locate the mapping input parameter that you want to bind the mapping output to. Double-click the
    Value
    column to view the selection arrow.
  3. Click the selection arrow to view a list of the parameters and variables that you can assign to the input parameter.
  4. Scroll to the
    User Outputs
    section of the list and choose the persisted mapping output to use.
    The following image shows Last_OrderDate_Parm mapping parameter on the Mapping task
    Input
    view:
  5. Select the mapping output to assign to the parameter.
    The mapping output name appears in the value column for the input parameter.
  6. Click
    File
    Save
    to save the Mapping task.
    The Last_OrderDate_Parm is bound to the persisted order date value from the repository.

0 COMMENTS

We’d like to hear from you!