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

Answer Posted / kumarn

Better to use Router t/r.In router the unmatched records
will goes to default group.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6759


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

1540


Explain sessions?

606


What are pre and post-session shell commands?

748


What is incremental aggregation?

577






What are the different versions of informatica?

685


Clarify the utilization of aggregator cache record?

580


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What is the use of transformation?

578


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.

789


What is the reusable transformation?

634


What is confirmed fact in dataware housing?

5697


What is the difference between informatica 7.0 and 8.0?

570


What is the fact table?

595


How to load the data from people soft hrm to people soft erm using informatica?

565