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
What is powercenter on grid?
What is the use of target designer?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is rank index in rank transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Mention some types of transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What do you mean by blocking transformation?
COM components can be used in Informatica
How can a transformation be made reusable?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
explain one complex mapping with logic? sales project?
Is it possible to revert a global repository to local one and why?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?