What is active and passive transformation?

Answer Posted / baiju

When a row enters a transformation, informatica assigns a
rownumber. if this number change for a row, that's an
Active transformation. In other words the nth row comming
IN will go as n'th row, then the transformation is PASSIVE.

Sorter is an active transformation!! IT never changes
the total row count, it changes only the order!!

Is This Answer Correct ?    15 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is target load order?

810


Explain incremental aggregation in informatica

661


What is main use of mapplet?

662


Differentiate between reusable transformation and mapplet.

581


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

777






Can anyone tell me the new features in Informatica 9 Version?

1533


What are the popular informatica products?

653


What do you mean by filter transformation?

557


Mention few power centre client applications with their basic purpose?

540


What is union transformation in informatica?

701


What is informatica metadata and where is it stored?

591


what is $$$$?

1742


In informatica workflow manager, how many repositories can be created?

786


What is a grid in Informatica?

616


What is the function of look up transformation?

653