Drag the DB Lookup component onto the Design window.
In the Design window, connect the DB Lookup’s IN-port with the OUT-port of the component that provides the inbound data.
In the Properties window, specify a valid interface and host name.
See “DB Lookup properties list” for specific field requirements.
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.
