DB Lookup Dynamic uses a query that references the key value in the query’s WHERE clause to perform a dynamic lookup. Unlike the DB Lookup component, DB Lookup Dynamic does not cache lookup information and performs one SQL lookup for each record that passes the component.
During project execution, the lookup table data might be modified by concurrent database users (or even within the same project). In cases like this, a non-dynamic database lookup might search for invalid data. Use DB Lookup Dynamic to ensure you locate the current value.
Another typical use case 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 as it performs the lookup on a record by record basis.
