Assume that you want to replace the product number used for German products by the product number used in the United Stated of America. 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
