What is Filter Transformation?

Filter transformation is an active, connected transformation.
The filter transformation is used to filter out rows in a mapping.
It may change the number of rows passed through it.
You have to specify a filter condition in the filter transformation.
The rows that meet the specified filter condition are passed to other transformations.
The rows that do not meet the filter condition are dropped.


 For example, for loading the employee records having deptno equal to 20 only, we can put filter transformation in the mapping with the filter condition deptno=20.

Step 1 – Create a mapping having source "EMP" and target "EMP_TAR"

source "EMP"

 target "EMP_TAR"

  

 mapping having source "EMP" and target "EMP_TAR"

Step 2 – Then in the mapping

1. Select Transformation menu
2. Select create option Filter Transformation from the list

Step 3 – The filter transformation will be created, Select "Done" button in the create transformation window.

Step 4 – In the mapping

1. Drag and drop  the Source qualifier columns to the filter transformation.

Step 5 – Double click on the filter transformation to open its properties, and then

1. Select the properties menu.
2. Click on the Filter condition editor.
3. Then in the filter condition expression editor.
4. Enter filter condition – deptno=20
5. Select OK button.

Step 6 – Now again in the edit transformation window in Properties tab you will see the filter condition, select OK button.

Step 7 – Link the columns from filter transformation to the target table.

Step 8 – Save the mapping.
1). create new workflow

Step 9 –   Create the connection ,link tasks and session.

Step 10 –   Save the workflow.

1) Right click and start workflow.
2) check the workflow monitor.

Step 10 –   Connect target database and check the emp_tar table.