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


Please Help Members By Posting Answers For Below Questions

What is an unconnected transformation?

764


How to generate or load values in to the target table based on a column value using informatica etl tool.

706


Differences between version 7.x and 8.x.

1521


How many ways are there to do 'remove duplicate records in informatica'?

672


How are indexes created after completing the load process?

1094






What are the new features of informatica 9.x developer?

634


What is workflow? What are the components of workflow manager?

808


Where can we find the throughput option in informatica?

700


How do you load only null records into target? Explain through mapping flow.

1628


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?

1630


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

641


As union transformation gives UNION ALL output, how you will get the UNION output?

730


Differentiate between router and filter transformation?

693


What is joiner transformation?

659


Make a note of the quantity vaults made in informatica?

655