The Database Value Lookup step allows you to lookup values in a database table based on data you have in your main stream.
The following screenshot shows the Database Value Lookup configuration window, which looks very similar to the Stream lookup step you already know:
In the upper section, you have the database connection and the table where you will look for data.
Then you have two grids:
- In the upper grid, you specify the keys to look up.
- In the lower grid, you put the name of the table columns you want back. These fields are added to the ...