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.
In the Properties window, specify the Key Attribute and Value Attribute. These are the Lookup values.
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.
