what are the type of transformations?

2 types:

1) active

2) passive.

   -- explain active and passive transformation?

      Active transformation can change the number of rows that pass through it.No of output rows less than or equal to no of input rows.

       Passive transformation does not change the number of rows.Always no of output rows equal to no of input rows.

Difference filter and router transformation.

 Filter transformation to filter the data only one condition and drop the rows don’t meet the condition.

Drop rows does not store any ware like session log file..

Router transformation to filter the data based on multiple conditions and give yiou the option to route rows that don’t match to a default group.