Oracle
1Z0-481 · Question #82
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…
The correct answer is A. SQLEXEC ( ). 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!
Data Transformation and Filtering
Question
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?
Options
- ASQLEXEC ( )
- BDBLOOKUP ( )
- CDBLOGIN ()
- DSQLLOOKUP ( )
How the community answered
(38 responses)- A76% (29)
- B8% (3)
- C13% (5)
- D3% (1)
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!
Topics
#SQLEXEC#lookup table#column transformation#target database
Community Discussion
No community discussion yet for this question.