What is the difference between a router and a filter
transformation?



What is the difference between a router and a filter transformation?..

Answer / sbvp

router filter
1.mutlipule conditions here 1.single condition here
2.send to multiple targets 2.single target
3.it captures the rejected records 3.it doesnot capture
in default output rejected records
group.
4.this is active t/r 4. this is also activet/r

Is This Answer Correct ?    18 Yes 1 No

Post New Answer

More Informatica Interview Questions

Tell me about informatica architecture.

2 Answers   TCS,


Roles and Responsibilties of Informatica Production Support Member?

6 Answers  


My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


What is the difference between Power Centre and Power Mart?

5 Answers   TCS,






How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,


what is mapping parameter?

2 Answers   Cap Gemini,


how to remove staging area

1 Answers  


1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


Categories