Developer Mapping Guide

10.4.0
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.2.2
- 10.2.1

Back Next

Step 4. Define the Filter Query

In the Read transformation, configure a filter query to read data incrementally based on a parameterized field and its value.

Select the Read transformation in the mapping editor to view the transformation properties.

Open the

Query

view.

Select the

Edit

button for the

Filter

property.

Configure a filter to find values that are greater than the persisted value using the following form: $<input port parameter> >
$<persisted value parameter>

Input port parameter is the mapping parameter col_id_name for the ID column from the source relational table.

Persisted value parameter is the mapping parameter col_id_val that you bind with the persisted mapping output value.

If you assign a value to the col_id_val parameter in a parameter set or parameter file, the query uses that assigned value for the parameter. Otherwise the query uses the persisted value, if one exists, or the default value.

Click

to save the filter query.

The filter query appears in the

Filter

property.

Click

File

Save

to save the Read transformation.

The following image shows the configured filter query: The Query view shows the configured filter for the Read transformation. The filter is defined as $col_id_name > $col_id_val.

The Query view shows the configured filter for the Read transformation. The filter is defined as $col_id_name > $col_id_val.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Step 4. Define the Filter Query

Step 4. Define the Filter Query