Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Join multiple tables in odi interface

1058736Dec 5 2013 — edited Jan 27 2014

Hi All,

I am new member to Oracle to Data integrator. This is a simple question but i haven't figure out.

I have four source tables and i need to apply joins (left, right and inner)between the table s and use some operators like(and,or) but i am unable to find the this option in odi. I have written a query in SQL Developer and executed it is working fine but when i paste the query in ODI it is showing Missing Expression error.

Thanks for your help,

Madhava

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2014
Added on Dec 5 2013
1 comment
10,371 views