By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / rajesh
Hi, We can do this in two ways.
By using Filter transformation and By using router transformation.
By using filter transformation take two filter transformations and take two targets one for given condition and another for unsatisfied condition.
By using Router Transformation create one new group and give the condition take two targets and create pipeline between router trans and target1 and default group to target2.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
How can we delete duplicate rows from flat files?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Why filter transformation is an active one?
How can repository reports be accessed without sql or other transformations?
Can you use flat files in Mapplets.
What do mean by local and global repository?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a passive transformation?
What is informatica etl tool?
What is the way to execute pl/sql script using informatica mapping?
Explain the different kinds of facts.
How to use procedural logic inside infromatica?
Explain what is informatica metadata and where is it stored?