Add and configure a DB Lookup Dynamic component to your project.
- Drag the DB Lookup
Dynamic component onto the Design window.
- In the Design window, connect the DB Lookups input port with the output port of the component that provides the inbound
data.
- In the Properties window, specify the interface
and host name.
- Specify the key attribute holding the value to look
for and value attribute to take the lookup result value. You can
replace a value by choosing the same attribute for both.
- Specify a lookup key value to be used when designing
and testing the lookup Query.
- Click the Query icon to open the Query window.
- On the Query window, create and save the query to
retrieve the lookup data. Design your query to return the lookup
value from the source table. Use the predefined variable Lookup
in the where clause of your Query as a placeholder
for the Lookup Key.