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 informatica metadata and where is it stored?
Mention some types of transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is aggregator transformation in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How can a transformation be made reusable?
What is an active transformation?
list out all the transformations which use cache?
Differentiate between joiner and lookup transformation?
explain abt ur project architecture?
What is a standalone command task?
How are indexes created after completing the load process?
Differentiate between reusable transformation and mapplet.
Did u used latest transformations of 8.6.0? for what?
Explain the aggregator transformation?