What is a filter transformation and why it is an active one?



What is a filter transformation and why it is an active one?..

Answer / Sanjay Kumar Piporiya

Filter Transformation in Informatica is used to select rows that meet certain criteria from the input data. It acts as a conditional statement that allows you to keep or discard rows based on specific conditions. Filter Transformations are considered Active Transformations because they process each row individually, which can impact performance if not properly optimized.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can we use mapping variables in informatica?

1 Answers  


In update strategy target table or flat file which gives more performance ? why?

7 Answers  


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


What are the types of presistent cache in look up tr.

1 Answers   IBM,


How we can create indexes after completing the loan process?

1 Answers  


What are the uses of a Parameter file?

3 Answers   CSC,


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,


My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,


Performance tuning( what you did in performance tuning)

1 Answers   Infosys,


without table how to come first record only in oracle?

1 Answers  


what is hash table in informatica?

1 Answers   Zensar,


Categories