Differnce between filter and router?

Answer Posted / ibrar ahmad

1). In filter we can give condition that has to be satisfy
else rows will get rejected where else router can replace
multiple filter and there is a default group in the router
which collect all the row which failed to satisfy the
condition in diffeent group in the router.

2). filter connected to a single target table where as
router
concted to multiple targets tables

3). Filter is active where as router can be active and
passive

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to elaborate tracing level?

687


Please let me know how to make Data masking in informatica..

1271


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

555


What is decode in static cache?

596


What is the session task and command task?

601






What is the different lookup cache(s)?

616


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

620


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1450


What is a filter transformation?

573


what is index?how it can work in informatica

1588


generate date / time dimension in informatica

724


Enlist some properties of sessions.

636


How to load data in informatica ?

582


Do you find any difficulty while working with flat files as source and target?

680


Partition, what happens if the specified key range is shorter and longer

2031