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
- 20417 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 rank transformation in informatica
What are some examples of informatica etl programs?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a rank transform?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the cumulative sum and moving sum?
What is a passive transformation?
What are pre and post-session shell commands?
What is union transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is the function of aggregator transformation?
How does the aggregator transformation handle null values?
What are data-driven sessions?
can u give example for factless fact table
How can we handle two sessions in informatica?
