Question - What is the use of a Lookup transformation?
Answer -
Lookup transformation is used for performing lookups by combining data in input columns with columns in the reference dataset. The reference table can be a new table or an existing table, view, or the SQL result query result.