What is the difference between filter and lookup transformation?

Submitted by: Administrator
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
Submitted by: Administrator

Read Online Informatica Data Warehousing Job Interview Questions And Answers