Add and configure a DB Lookup component.
- Drag the DB Lookup
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 a valid 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.
- In the Properties window, 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
key and the lookup value from the source table.