December 2014
Intermediate to advanced
362 pages
8h 12m
English
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 record that returns FALSE, the Filter transformation drops the records.
To add the Filter transformation, double-click on the ...
Read now
Unlock full access