Assume you want to replace the product number used for German products by the product number used in the U.S. The German products are in the table PRODUKTE(PR_NUMMER, PR_NAME, PR_PREIS). Your IN-port at DB Lookup Dynamic component therefore contains those three attributes.
The table to lookup the U.S. product number is table LOOKUP_PRODUCTS(SOURCE, DESTINATION). The SOURCE column contains the German product numbers and the DESTINATION column contains the U.S. product number.
If no value for the German PR_NUMMER can
be found in the LOOKUP_PRODUCTS, the
current PR_NUMMER will be replaced
by the string “INVALID”.
A successful lookup will replace the German product number by the
corresponding U.S. number.
To set up the DB Lookup Dynamic component for this example, select:
Key Attribute: PR_NUMMER
Value Attribute: PR_NUMMER
Default Value: INVALID
Query: select DESTINATION FROM LOOKUP_PRODUCTS, where SOURCE = ‘[Lookup]’
