Lookup and filter transformation

Write down the differentiation between lookup and filter transformation?

E

Expert

Verified

i) Filter transformation is Active transformation as well as Lookup is a Passive transformation

ii) Filter transformation is employed to filter rows based on the condition and Lookup is employed to look up data in the flat file or relational table, synonym, or view.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.