Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What are the various tasks can be performed by Lookup Transformation? Ans:- Get a related value, Get multiple values, Perform a calculation, Update slowly changing dimension […]