Assume that 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). The IN-port of the DB Lookup component contains those three attributes.
The table to perform the lookup of the U.S. product number is 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 is replaced by the string “INVALID”. A successful lookup replaces the German product number by the corresponding U.S. number.
To set up the DB Lookup Component for this example, select:
Key Attribute – PR_NUMMER
Value Attribute – PR_NUMMER
Default Value – INVALID
Query – select SOURCE, DESTINATION FROM LOOKUP_PRODUCTS