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
Explain how to import oracle sequence into informatica?
What is difference between a gateway node and worker node?
What are the advantages of informatica?
What is the difference between a repository server and a powerhouse?
what is the size of u r source(like file or table)?
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
Explain the types of lookup transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the advantages of using informatica as an etl tool over teradata?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are active and passive transformations?
list out all the transformations which use cache?
What is dynamic cache?
Can u generate reports in Informatica?
Can we create a Integration service without a Repository service and vice versa?