By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / nikunj
Don't use filter transformation.
Router transformation is a better option in this scenario.
| Is This Answer Correct ? | 50 Yes | 5 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
have u done any performance tuning? how u ll do?
What differs when we choose the sorted input for aggregator transformation?
Different sorts of metadata that stores in the storage facility?
How to create the source and target database connections in server manager?
Differentiate between source qualifier and filter transformation?
which one is better performance wise joiner or look up
What is native users?
How to join three sources using joiner? Explain though mapping flow.
What is data caches/ index caches?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can repository reports be accessed without sql or other transformations?
Which transformation is needed while using the Cobol sources as source definitions?
What is substr in informatica?
How to create a non-reusable instance of reusable transformations?