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
How can we delete duplicate rows from flat files?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Parameter and variable differences
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
If informatica has its scheduler why using third party scheduler?
In informatics server which files are created during the session rums?
What is a router transformation?
What is exclusive and normal mode for repository services?
What are the different transaction levels available in transaction control transformation?
How many numbers of sessions can one group in batches?
Explain how many types of dimensions are available in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the scenario which compels informatica server to reject files?