⟩ What is the difference between filter and lookup transformation?
1) Filter transformation is an Active transformation and Lookup is a Passive transformation
2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data in a flat file or a relational table, view, or synonym