Router Transformation

Hi Gurus,

 The Following videos explain how to do Router Transformation using ODI.


 Hope you will learn several ODI features by watching these videos

 Thanks & Regards
 WWW.ODIGURUS.COM

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 ,

ODI FILTER

Hi Gurus,


Today let us see the video how the filter transmission is implemented using ODI.

In this example i took EMP table as my source where i applied the filter condition.


I hope you enjoy the vedio.

Thanks Gurus,

Ram kumar Lanke