JOIN TRANSFORMATION

Hi Gurus,

Now i  am going to show you how to implement Joiner transformation in ODI.

Open the Designer
Expand the project
Right click on interfaces
And click on new interface
Give the name as INF_TRG_EMP_JOIN

 Drag and drop EMP and DEPT from the SRC_SCOTT model on to the source pane
Drag the DEPTNO column from EMP table and drop on DEPTNO column of DEPT table , then it will create a join. click on join then you will see the JOIN properties below
Drag and Drop TRG_EMP_DEPT_JOIN from TRG_SCOTT model on to the target pane
Click ok to perform Automatic mapping

 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