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

Answer Posted / abidu

Connect the ports of the filter transformation to the
second target table and enable the 'FORWARD REJECTED ROWS'
in the properties of the filter transformation. the
rejected rows will be forwarded to this table.

pls let meknow if i m wrong anywhere.

Is This Answer Correct ?    13 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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


While migrating the data from one environment to another environment how would you manage the connections?

723


What is aggregator transformation in informatica?

629


How are indexes created after completing the load process?

1094


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1981






can anyone explain me about retail domain project in informatica?

7566


Where are the source flat files kept before running the session?

721


Global and Local shortcuts. Advantages.

1566


What is rank transform?

675


wf dont have integration severances how you can run?

1618


Explain about cumulative Sum or moving sum?

703


What is the need for an etl tool?

738


What are the different versions of informatica?

797


What is the command used to run a batch?

663


How to elaborate tracing level?

789