Database Reference
In-Depth Information
The Filter transformation
Filter transformation is used to remove unwanted records from the mapping. You can
define the filter condition in the Filter transformation, and based on the filter condition, the
records will be rejected or passed further in the mapping.
A sample mapping showing the Filter transformation is given in the following screenshot:
The default condition in Filter transformation is
TRUE
. Based on the condition defined, if
the record returns
TRUE
, the Filter transformation allows the record to pass. For each re-
cord that returns
FALSE
, the Filter transformation drops the records.
To add the Filter transformation, double-click on the Filter transformation and click on the
Properties
tab, as shown in the following screenshot:
