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


Please Help Members By Posting Answers For Below Questions

Explain the use of aggregator cache file?

680


How to generate sequence numbers using expression transformation?

648


What is the use of an aggregator cache file?

695


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1322


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5268






How do you convert single row from source into three rows into target?

609


While importing the relational source definition from the database, what are the metadata of source that will be imported?

797


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

736


can anyone explain me about retail domain project in informatica?

7442


What are pre and post-session shell commands?

748


what are the deliverables?in your project?

1665


What is domain and gateway node?

702


What the difference is between a database, a data warehouse and a data mart?

599


What are different types of transformations available in informatica?

590


What are the different versions of informatica?

685