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!