The lookup transformation is used to extract values from a data source based on certain lookup conditions. There are a few circumstances when this may be required, such as to:

Update a dimension table

Check to see if any records in a table already exist.

Locate a specific value in a table