ETL TESTING Questions and Answers

What is the uses of Lookup Transformation?

The Lookup Transformation is useful for:
1. Getting a related value form a table using a key column value
2. Update slowly changing dimension table
3. To check whether records already exists in the table.