Hi Guys,

First of all Every Active tranformation is a Passive 
transformation,But every passive not Active.

In Router Transformation there is a special feature with 
Default Group.Because of Default Group its Passive.
We can avoid this Default group by Some transformation 
Settings,Now its Active.    

any queries let me know
srinu.srinuvas@gmail.com,,,,,

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

AS  srinu said All Active can act as passive. Active TR
means the number of rows which is the input to the
Transformation will decrease in the  output from that
transformation . 


For example :- i have emp table if  i write a condition
where sal>2000 then the  rows will decrease after this
transformation . same when i  didn't apply any condition
then that acts as Passive transformation

@Answer2: See, you mean to say input to the router is 15 
and output is 20 so router tr is active. if that is the 
case, we can take one row from the expression and connect 
it to two transformation, so do u say expression is also 
active?