By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / nagarjuna redd
Use router transformation to load the rejected data.
Connect output ports(i.e: condition satisfied records) to
the one target table and connect default ports(not
satisfied records) to the another target
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Why update strategy and union transformations are active?
What are the tuning techniques you applied during your last project
Write the unconnected lookup syntax and how to return more than one column.
What are the different versions of informatica?
What is a passive transformation?
What are the different types of olap? Give an example?
Explain the mapping variable usage example in informatica
What are junk dimensions?
tell me 5 session failure in real time how can you solve that in your project?
How to create a non-reusable instance of reusable transformations?
What is meant by pre and post session shell command?
What are multi-group transformations?
What is rank transformation in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?