By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / yogesh
Use Router tranformation. All the rows which doesnot match
the group (filter condition) will be routed to default
group. Connect default group ports to 2nd target.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
What is data movement mode in Informatica and difference between them?
What is a pre-defined event and user-defined event?
Explain the types of transformations?
What is a filter transformation and why it is an active one?
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.
Explain lookup transformation is active in informatica
What are the designer tools for creating transformations?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the transformations that are not supported in mapplet?
Clarify the utilization of aggregator cache record?
what is the Default Source Option For Update Strategy Transformation?
In informatica workflow manager, how many repositories can be created?
Whats there in global repository