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 Filter transformation and click on the Properties tab, as shown in the following screenshot:
Click on the button shown in the preceding screenshot to open the expression editor and add the function for the filter condition. Then, add the required condition. We have used the condition as DEPARTMENT_ID=100
; this will allow records with DEPARTMENT_ID
as 100
to reach the target, and the rest of the records will get filtered.
We have understood the functionality of Filter transformation in the above section and next we will talk about Router transformation, which can be used in place of multiple filters.