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