Answer Posted / bhanu prakash
->filter transformation is used for only one condition
where as router transformation is used for multiple conditions
->in filter transformation there is only one target,where as
in router transformation there is more than one targets.
-> filter is like where condition in SQL
router transformation is like SUB Query in SQL
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
How can informatica be used for an organization?
What is a connected transformation?
How to generate sequence numbers without using the sequence generator transformation?
What do you mean by channel change?
Explain target update override in informatica
Differentiate between Load Manager and DTM?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the meaning of up gradation of repository?
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?
Sequence generator, when you move from develoment to production how will you reset
On which transformations you created partitions in your project?
What can we do to improve the performance of informatica aggregator transformation?
Why filter transformation is an active one?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION