What Is The Difference Between Filter And Lookup Transformation?

1.	What Is The Difference Between Filter And Lookup Transformation?
Answer» Filter transformation is an ACTIVE transformation and Lookup is a Passive transformation. Filter transformation is used to Filter ROWS based on condition and Lookup is used to LOOK up data in a FLAT file or a relational table, view, or SYNONYM.

Answer»

Filter transformation is an ACTIVE transformation and Lookup is a Passive transformation.
Filter transformation is used to Filter ROWS based on condition and Lookup is used to LOOK up data in a FLAT file or a relational table, view, or SYNONYM.

Discussion