Lookup Transformation

A Lookup Transformation is a data process that retrieves related information from a secondary data source based on matching fields. For example, it can find a customer's current address from a customer ID stored elsewhere. It helps integrate and enrich data by bringing in additional details, allowing for more complete and accurate analysis or reporting. Think of it as searching for a key piece of information in a reference table to complement your existing data.