By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / aruna
Use another Filter Xn with the reverse condition and get the discared rows.
There is no such property in Filter Xn to "Forward Rejected Rows" as mentioned above in one of the answers.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
How many number of sessions can one group in batches?
In which transformation you cannot drag ports into it?
How does a sorter cache works?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the difference between router and filter?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the restrictions of union transformation?
What is the advantage of informatica?
What are the modules in Power Center
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is Index Caches size?
What is the function of union transformation?