Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Creating a Mapping

Creating a Mapping

Create a mapping that contains a reusable Filter transformation. The Filter transformation filters rows that have order dates less than a specific date. The filter expression includes a parameter called Last_Order_Date_Parm.
  1. Create a mapping to process order data from a Customer_Order file.
  2. In the mapping Properties view, click the
    Parameters
    tab.
  3. Add a date/time mapping parameter called Last_Order_Date_Parm.
    Enter a default date for the starting parameter.
    The following image shows the mapping parameter:
  4. Create a reusable Filter transformation to filter Customer_Order rows.
  5. Define a parameter in the Filter transformation called Order_Filter.
    Enter a default date for the starting parameter.
  6. Add a filter expression to find order dates that are greater that the parameter:
  7. Add the Filter transformation to the mapping.
  8. Click the Filter transformation to display the transformation
    Properties
    view.
  9. Click the
    Parameters
    tab.
  10. To bind the Order_Filter_Parm transformation parameter to the Last_Order_Date mapping parameter, click the
    Instance Value column
    for the Order_Filter_Parm.
  11. Select Last_Order_Date.
    The following image shows where the mapping parameter is bound to the transformation parameter:

0 COMMENTS

We’d like to hear from you!