Before Categorizing them, its better to recall the defintions of both types.

Active Transformation -
An Active transformation can change teh number of rows that pass through it from source to traget. It eliminates rows that do not meet the condition in transformation.

Passive Transformation -A Passive transformation does not change teh number of rows that pass through it i.e., it passes all rows through the transformation.

List of transformations coming under Active transformations are -

• Source Qualifier Transformation
  
• Aggregator Transformation
  
• Filter Transformation
  
• Rank Transformation
  
• Joiner Transformation
  
• Router Transformation
  
• Normalizer Transformation
  
• Update strategy Transformation
  
• Sorter Transformation
  
• ERP Source Qualifier Transformation
  
• Advanced External Procedure Transformation

And here find the Passive Transformations list -

• Expression Transformation
  
• Sequence Generatoe Transformation
  
• LookUP Transformation
  
• Stored Procedure Transformation
  
• XML Source Qualifier Transformation
  
• External procedure Transformation
  
• Input Transformation(Mapplet)
  
• Output Transformation(Mapplet)

Karthik,

As per the definition, the Expression, Lookup, Stored Procedure and Sequence generator Transformations donot change the number of rows passing through them, thats why these will come under Passive.