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

Answer Posted / nagarjuna redd

Use router transformation to load the rejected data.
Connect output ports(i.e: condition satisfied records) to
the one target table and connect default ports(not
satisfied records) to the another target

Is This Answer Correct ?    20 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is $$$$?

1742


What is lookup transformation?

605


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1879


How can you define user defied event?

624


can we override a native sql query within informatica? Where do we do it? How do we do it?

602






How to do the error handling of if ur source is flatfiles?

1515


What are pre and post-session shell commands?

748


What is a grid in Informatica?

617


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1560


How do you migrate data from one environment to another?

651


What is difference between a gateway node and worker node?

630


What is a stored procedure transformation?

611


what is the size of u r source(like file or table)?

1820


How identifying bottlenecks in various components of informatica and resolving them?

587


generate date / time dimension in informatica

727