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
Is there any target staging area in informatica not staging area
What are the advantages of using informatica as an etl tool over teradata?
Define Pmrep command?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Mention few advantages of router transformation over filter transformation.
What are the tuning techniques you applied during your last project
What are the issues you have faced in your project? How did you overcome those issues?
What is status code in informatica?
Can we create multiple integration service on single repository?
What are data-driven sessions?
Which are the different editions of informatica powercenter that are available?
How to join three sources using joiner? Explain though mapping flow.
What are the new features of informatica 9.x at the developer level?
What is expression transformation?
Is it possible to create multiple domains on a single Informatica server?