FILTER INTERFACE

Hi Gurus,

Let us study how to develop filter transformation using ODI.
Create a new interface with the name "INF_TRG_EMP_FIL1"
CLICK ON MAPPING TAB

 Drag and drop EMP  from the SRC_SCOTT model on to the source pane
Drag and Drop TRG_EMP_FIL1 from TRG_SCOTT model on to the target pane
Click ok to perform Automatic mapping

To create a filter Drag and drop the SAL column of EMP source on to the empty space
Click on the filter symbol which apears
Now you can see the filter properties in the property inspector
enter the filter condition as EMP.SAL<2500
Click on save
Click on FLOW tab

Click on Target to see the IKM target properties
Set the "flow_control" option to false
Set the "Truncate" option to true
Click on save
Click on execute

Go to operator log
Check the log for this session
Open it and check the number of inserts

Assignments:
1. Create a mapping with filter condition as EMP.SAL>1000 between EMP data source of SRC_SCOTT model and TRG_EMP_FIL2 data store of TRG_SCOTT model

 2. Create a mapping with filter condition as EMP.SAL>=3000 between EMP data source of SRC_SCOTT model and TRG_EMP_FIL3 data store of TRG_SCOTT model

Thanks & Regards
WWW.ODIGURUS.COM