Skip to Main Content
Forums

GoldenGate

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!

Using GoldenGate SQLEXEC For Lookup Queries

Art TMar 29 2011 — edited Mar 31 2011
My target table T is the rsult of joining two source tables - S1 and S2. For each new row in S1 I need to look up S2 attributes and apply combined result to T.
I am not able to find any extamples of this functionality inplemented on the source. All examples I have seen are implemented in the MAP statement on the target.

I was able to use SQLEXEC on the target to call lookup proc on the source via dblink. That seems backwards.
Is there a better way to do this?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2011
Added on Mar 29 2011
#goldengate
6 comments
895 views