ODI JOIN

Hi Gurus,

Today i am sharing the video which explains how to do join between two tables using ODI.

In this video i used to perform join between EMP and DEPT table using the following condition

EMP.DEPTNO=DEPT.DEPTNO

And the result is stored in a table called EMP_DEPT.

For this i had created a data store with the name EMP_DEPT with all columns from EMP data store and two columns LOC and DNAME from DEPT.

The interface KM option "Create Target Table" is set to true to create target table at run time.

Hope this will useful to understand some good features of ODI 

Thanks ,