Interested to Buy Any Domain ? << Click Here >> for more details...
Router T/R is active but some people are saying it is also
passive which is exactly right?
- 5 Answers
- 20619 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh.a
Hi,
Router is Active Transformation only.Take a small example.Lets say emp table is having salaries between 1000 and 2000.and no.of records of salary 1000 is 5 and no.of records of salary 2000 is 5 and no.of records of salary 1500 is 5 .
Now in Router we will create 2 groups and and conditions are 1group-salary >=1000 and salary <=1500 --will give 10 rows
2group-salary >=1500 and salary <=2000 --will give 10 rows
so input rows are 15 and output rows are 20.So there is a change in no.of.rows between input and output.So Router is active
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
Did u used latest transformations of 8.6.0? for what?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to open an older version of an object in the workspace?
Clarify the aggregator change?
What is the status code in stored procedure transformation?
What is data caches/ index caches?
What are session parameters ? How do you set them?
How to use procedural logic inside infromatica?
What are the types of presistent cache in look up tr.
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a passive transformation?
How to load a Dimension ? and how to load a fact table?
What is mapping debugger?
What are the different components of powercenter?
