Developer Workflow Guide

10.5.3
- 10.5.6
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

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.

Create a mapping to process order data from a Customer_Order file.

In the mapping Properties view, click the

Parameters

tab.

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:

Create a reusable Filter transformation to filter Customer_Order rows.

Define a parameter in the Filter transformation called Order_Filter.

Enter a default date for the starting parameter.

Add a filter expression to find order dates that are greater that the parameter:

Add the Filter transformation to the mapping.

Click the Filter transformation to display the transformation

Properties

view.

Click the

Parameters

tab.

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.

Select Last_Order_Date.

The following image shows where the mapping parameter is bound to the transformation parameter:

Rename Saved Search

Table of Contents

Developer Workflow Guide

Developer Workflow Guide

Creating a Mapping

Creating a Mapping