Informatica Data Warehousing Question:
Download Questions PDF

What is the difference between filter and lookup transformation?

Answer:

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

Download Informatica Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between informatics 7x and 8x and what is latest version?Explain How to import oracle sequence into Informatica?