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

Answer Posted / prasad.bluesky

it is possible to see the rejected rows after filter
transformation solution is create an empty file and write
that file name in $rejectfile option in session then after
run your session see your created file it contains rejected
rows.

Is This Answer Correct ?    10 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

592


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1126


How can we delete duplicate rows from flat files?

739


What is the difference between Active and Passive transformation?

632


What is the sequence generator transformation in informatica?

613






Different qualification between a related rotate toward the sky and isolates look upward?

552


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1530


Explain the etl program with few examples.

547


What are the limitations of joiner transformation?

651


What are the tuning techniques you applied during your last project

1561


What is fact table? Explain the different kinds of facts.

613


What is powercenter on grid?

692


Mention a few design and development best practices for informatica?

559


can anyone explain me about retail domain project in informatica?

7433


What are some examples of informatica etl programs?

533