In general, a Lookup operation looks up a value corresponding to a key in a Lookup table containing a list of (key, value) pairs. A static Lookup table can be cached during the execution of a project, or the Lookup can be performed uncached and dynamically.
The Lookup components are:
The DB Lookup component performs a cached lookup in a database.
The DB Lookup Dynamic component performs an uncached, dynamic lookup in a database.
