You have source table with PRODUCT-ID column and target table with
PRODUCT_DESCRIPTION. On the target database is a lookup table containing product
codes and corresponding description. What is good way for you to lookup the product
description for each transaction?
A.
SQLEXEC ( )
B.
DBLOOKUP ( )
C.
DBLOGIN ()
D.
SQLLOOKUP ( )
Explanation:
In reference guide, page 236, in example 1 or Example 2, when a lookup is
available, SQLEXEC() is the function to use.
Incorrect answer:
There isn’t a SQLLOOKUP() function in GoldenGate!
Maybe A.