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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2014

Added on Dec 5 2013

#11g, #data-service-integrator, #soa-process-management

1 comment

10,372 views