A lookup transformation allows users to access data from relational tables that are not defined in mapping documents. It enables users to update slowly changing dimension tables to determine whether the records already exist in the target or not.

BY Best Interview Question ON 26 Jan 2019