This component performs a dynamic lookup by using a query referencing the key value in the WHERE clause. Unlike the DB Lookup component, the DB Lookup Dynamic performs one SQL lookup for each record that passes the component and caches no lookup information.
During execution of a project, the data of a lookup table might be modified by concurrent database users (or even within the same project). In this case, a non-dynamic database lookup would look up data that might be no longer valid. To verify that the current value is looked up, use the DB Lookup Dynamic component.
Another typical use for this component is a lookup table that exceeds the memory available on the local machine. By using the DB Lookup Dynamic component, the lookup is slower but requires no cache memory, because it performs the lookup on a record-by-record basis.
Add the component to the project and connect the ports to adjacent components.
