By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 45068 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
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
Can we get 1st record through Informatica(without sequence number).
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is a code page?
How to go to the older version for a mapping?
can we override a native sql query within informatica? How do we do it?
How do you set a varible in incremental aggregation
How do you handle two sessions in Informatica
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What are the types of lookup transformation?
Write the unconnected lookup syntax?
How do you load alternate records into different tables through mapping flow?
Can you generate sequence numbers without using the sequence generator transformation?
Differentiate between a database and data warehouse?
What is intricate mapping?
