User`s guide

Using Lookup components
106 Sybase IQ ETL 4.1
For example, 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 component therefore contains those three attributes.
The table to lookup the US 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, choose:
• Key Attribute:
IN.PR_NUMMER
• Value Attribute: IN.PR_NUMMER
• Default Value: ‘INVALID’
•Query: SELECT DESTINATION FROM LOOKUP_PRODUCTS, where
SOURCE = ‘[LOOKUP]’
Refer to the “Entering database connection parameters” on page 71 for more
information on the previous and the following properties:
• Database
• Schema
• Standardize Data Format
• Database Options
There is no impact on the simulation sequence.
View Projects in DemoRepository and Help Flash movie Demo DB Lookup
Dynamic.