What is the difference between Stream Lookup and Database Lookup?
Stream Lookup
The Stream Lookup step is used to enrich data in a workflow by looking up values from another source (such as a file or secondary stream). Data from source steps is cached in memory, and a common key field is used to match and retrieve the required values. The matched data is then added to the main data stream.
Database Lookup
The Database Lookup step is used to fetch values directly from a database table. Based on a key field, it retrieves matching records and adds the lookup values as new fields to the existing data stream.
