What is Active & Passive Transformation ?

What is Active & Passive Transformation ?

Active and Passive Transformations

         Transformations can be active or passive. An active transformation can change the number of records passed through it. A 

         passive transformation never changes the record count.For example, the Filter transformation removes rows that do not 

         meet the filter condition defined in the transformation

Active transformations that might change the record count  include the following:
• Advanced External Procedure
• Aggregator
• Filter
• Joiner
• Normalizer
• Rank
• Source Qualifier
         Note: If you use PowerConnect to access ERP sources, the ERP Source Qualifier is also an active transformation.
     /*
         You can connect only one of these active transformations to the same transformation or target, since the Informatica
         Server cannot determine how to concatenate data from different sets of records with different numbers of rows.
     */
         Passive transformations that never change the record count include the following:
• Lookup
• Expression
• External Procedure
• Sequence Generator
• Stored Procedure
• Update Strategy
     
You can connect any number of these passive transformations, or connect one active transformation with any number of
         passive transformations, to the same transformation or target.