Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - All active transformations are passive or not?




1966
views
asked marvit December 5, 2014 07:44 AM  

All active transformations are passive or not?


           

2 Answers



 
answered By vikram   0  
This answer is pending moderator approval no except aggregator all acts like active or passiveĀ 
but aggregator always active
flag   
   add comment

 
answered By Nagapuri   0  

Some transformations are by default passive when we give condition it will act like active ex : filter.

Sorter is default passive but when you give distinct option it will be active.

some active transformations may not be passive by default ex:aggregator transformation,if we are not selecting group by on any port it will give last row...

so conclsuion: some active transformations are by default passive and some may not.

flag   
   add comment

 
answered By vishnoiprem   0  
An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and passes through the same number of rows that was given to it as input.

Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition. A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformationActive transformations Advanced External ProcedureAggregatorApplication Source QualifierFilterJoinerNormalizerRankRouterUpdate Strategy  Passive transformation ExpressionExternal ProcedureMaplet- InputLookupSequence generatorXML Source QualifierMaplet - Output
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert