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
- 20189 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
What is difference between a gateway node and worker node?
Write the prerequisite tasks to achieve the session partition?
What will be the approach?
Explain the different lookup methods used in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the new features of informatica 9.x in developer level?
Sequence generator, when you move from develoment to production how will you reset
How do you take back up of repository?
What is workflow manager?
generate date / time dimension in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Define update strategy?
What are the main issues while working with flat files as source and as targets ?
What is the advantage of informatica?
