Skip to Main Content

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?
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 28 2011
Added on Mar 29 2011