User`s guide

Using Lookup components
104 Sybase IQ ETL 4.1
• 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.
DB Lookup Dynamic component
This component performs a dynamic lookup by using a query referencing the
key value in the
WHERE clause. Unlike the DB Lookup component, the DB
Lookup Dynamic performs one SQL lookup for each record that passes the
component and caches no lookup information.
During execution of a project, the data of a lookup table might be modified by
concurrent database users (or even within the same project). In this case, a non-
dynamic database lookup would look up data that might be no longer valid. To
verify that the current value is looked up, use the DB Lookup Dynamic
component.
Another typical use for this component is a lookup table that exceeds the
memory available on the local machine. By using the DB Lookup Dynamic
component, the lookup is slower but requires no cache memory, because it
performs the lookup on a record-by-record basis.
Add the component to the project and connect the ports to adjacent
components.
Required properties
Select a Key Attribute from the list of IN-Port attributes. This attribute
corresponds to the first column of the lookup table.
Value Attribute
Select the attribute to receive the value returned by the lookup from the Value
attribute list. The lookup value returned will overwrite any existing value.
Both Key Attribute and Value Attribute might refer to the same attribute of the
record structure therefore allowing overwriting a key with its corresponding
value.