ODI Join Transformations

1. TRUNCATE option
2. CREATE_TARG_TABLE option
3. Filter transformations-- OR, AND, NOT NULL
4. Join transformation- left outer , right outer and inner join
5. Duplicate existing data store to create new data store
6. duplicating the interface and modifying it
7. Lookup transformation
8. How to view the code and observe the operator log

 

Open the below links for implementation details

FILTER INTERFACE

 SIMPLE INTERFACE

http://www.youtube.com/watch?

v=1o3iBIQV7-M&feature=related

ORACLE DATA INTEGRATOR: JOIN INTERFACE - YouTube

JOIN Transformation

Lookup transformation


To Create a new data sore with existing data  store structure

1. select the data store  TRG_EMP_DEPT_JOIN and right click and click on duplicate selection
2. Now a copy of TRG_EMP_DEPT_JOIN data store will be created
3. open the copy of data store and modify the following tabs
    Name : TRG_EMP_DEPT_LJOIN
    Alias: TRG_EMP_DEPT_LJOIN
    Resource name: TRG_EMP_DEPT_LJOIN
4. click save and close


CONDITION FOR NON EQUI-JOIN:

EMP.SAL BETWEEN SALGRADE.LOSAL AND SALGRADE.HISAL


SELF JOIN:
DRAG DROP EMP DATA STORE 2 TIMES ON TO SOURCE
DRAG DROP TRG_EMP_EMP ON TO TARGET

JOIN CONDITION:
EMP.EMPNO=EMP1.MGR