Transformation can be active or passive, active transformation can change the no of records passed to it, a passive transformation can never change the records count.
Active transformation:- that might change the record count are aggregator, filter, joiner, Normalizer, rank, update strategy, source qualifier If u use power connector to access ERP sources, ERP source qualifier is also an active transformation
Passive transformation:- lookup, expression, external procedure, sequence generator, stored procedure U can connect only 1 active transformation to the same transformation or target can connect any no of passive transformations.
A nice aricle on Active and passive transformation :-
ReplyDeletehttp://www.tecktricks.com/active-and-passive-transformation-in-informatica/