Example

Assume you want to replace the product number used for German products by the product number used in the US. The German products are in the table PRODUKTE(PR_NUMMER, PR_NAME, PR_PREIS). Your IN-port for the DB Lookup Dynamic component therefore contains these three attributes.

The table to look up 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 US. 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 with the corresponding US. 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]’

Parent topic: DB Lookup Dynamic