By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?

Answer Posted / aruna

Use another Filter Xn with the reverse condition and get the discared rows.
There is no such property in Filter Xn to "Forward Rejected Rows" as mentioned above in one of the answers.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by filter transformation?

557


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

716


What is the benefit of session partitioning?

601


How can we use mapping variables in informatica?

602


In informatica workflow manager, how many repositories can be created?

786






What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1470


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1978


What are the different types of repositories created using informatica?

663


What does refresh system mean, and what are its distinctive choice?

569


what is the hint? how to use it to reduce the query processing in program?

6329


What is persistent lookup cache?

607


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1690


In development project what is the process to follow for an etl developer from day1

1286


list out all the transformations which use cache?

693