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

Answer Posted / yogesh

Use Router tranformation. All the rows which doesnot match
the group (filter condition) will be routed to default
group. Connect default group ports to 2nd target.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of look up transformation?

650


What is a repository? And how to add it in an informatica client?

650


Under which circumstances, informatica server creates reject files?

589


Explain the features of connected and unconnected lookup.

544


How to do unit testing in informatica?

718






What is meant by lookup transformation? Explain the types of lookup transformation?

567


What is the function of aggregator transformation?

575


What are the mapping parameters and mapping variables?

623


What are the advantages of using informatica as an etl tool over teradata?

567


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

782


hi real timers . iam waiting for ur reply regarding ETL TESTING

1805


What is resilience time?

653


What is update strategy transform?

570


how tokens will generate?

1735


What are the different transaction levels available in transaction control transformation?

673