Skip to Main Content
Forums

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!

How to execute a SQL Query fetching the data from Two different databases in ODI Procedure

1018668Aug 20 2015 — edited Aug 20 2015

Hi Team,

I want to trigger the below query in ODI Procedure but I don't know how to do that since both tables resides on different databases:

Query Is:

select * from SYSTEMB TRG where not exists (select * from SYSTEMA SRC

where trg.store = src.store and trg.item = src.item)

SystemA and SystemB tables both are in two different databases.

Could you please help me in this.

Thanks

Regards,

Jiten
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2015
Added on Aug 20 2015
#data-service-integrator, #soa-process-management
0 comments
682 views