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
What are the transformations that are not supported in mapplet?
State the limitations where we cannot use joiner in the mapping pipeline?
Can we override a native sql query within informatica?
In how many ways we can create ports?
Define mapping and session?
What is meant by lookup transformation?
How can you increase the performance in joiner transformation?
what are the deliverables?in your project?
What do you understand by SOA of Informatica?
What do mean by local and global repository?
Explain incremental aggregation in informatica
What are different types of transformations available in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
can we override a native sql query within informatica? Where do we do it? How do we do it?
How we can create indexes after completing the loan process?