Drag the DB Lookup Dynamic 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 the interface and host name.
See “DB Lookup Dynamic properties list” for specific field requirements.
Specify the Key Attribute and Value Attribute. These are the Lookup values.
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.
Resetting the Lookup key value
To reset the value of the Key Attribute and Value attribute properties of the component to default:
Right-click the DB Lookup Dynamic component.
Select Reset Lookup Key value.
