What will happen if we have a filter transformation used in
a mapping and in the filter condition we specify 1. Yes
nothing else, only the number 1. In other words, assuming we
have 10 rows coming to this filter transformation as an
input, how many rows will be output by this transformation
when we have only 1 in the filter condition?
Answer Posted / pavan
THE FILTER CONDITION IS 0 THE SESSION WILL BE FAIL
THE FILTER CONDITION IS NON ZERO MEANS LIKE 1,2,3....IS TRUE THEN IT PROCESS ALL THE ROWS WITH OUT FILTERING ANY DATA
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is expression transformation?
Differentiate between Load Manager and DTM?
differences between service based and product based?
What is the use of transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Is stop and abort are same in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Why is sorter an active transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the issues you have faced in your project? How did you overcome those issues?
What is native users?
What do you mean by filter transformation?
What is workflow? What are the components of the workflow manager?
Performance tuning( what you did in performance tuning)
Design a mapping to load a target table with the following values from the above source?