Using GoldenGate SQLEXEC For Lookup Queries
Art TMar 29 2011 — edited Mar 31 2011My 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?