ODI 12c :- Oracle Data Integrator 12c Filter example.

In this post I am going to explain how to add a filter to ODI mapping. For  this tutorial,
I am using previously posted article (http://pubududewagama.blogspot.com/2017/08/odi-12c-create-simple-mapping-etl-job.html) to apply the filter.
According to my previous post , it loads data one to one table. 



In here I am going to create a filter to load only DEPTNO = 20 data into destination table.
First select the DEPTNO attribute in the EMPLOYEE table and drag and drop to the default area.


Then Click on the Filter icon and go to the Properties windows(Manu Bar –> Windows—>Properties).


Then click on the Corner of the filter condition and updated as below to apply the filter condition.

Updated as below.

Save and Execute the mapping.Output will be as below.


Thank you !!!