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 |
How can we use mapping variables in informatica?
In update strategy target table or flat file which gives more performance ? why?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
What are the types of presistent cache in look up tr.
How we can create indexes after completing the loan process?
What are the uses of a Parameter file?
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?
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?
Performance tuning( what you did in performance tuning)
without table how to come first record only in oracle?
what is hash table in informatica?