What is active and passive transformation?

Answer Posted / atiric softwares(raja)

An active transformation can change the no. of rows that
passes through it eg: filter transformation passes the rows
from the source to target that which meet the filter condition.


an passive transformation cannot change the rows that which
passes through it eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target

Is This Answer Correct ?    25 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways are there to create ports?

731


What are active and passive transformations?

654


What is a code page?

718


Can we create a node as a gateway node and the same node can be assigned to a grid?

641


What is transformation?

663






Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2286


What is an aggregator transformation?

617


What is informatica worklet?

612


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

556


What does refresh system mean, and what are its distinctive choice?

568


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3516


Can we create multiple integration service on single repository?

705


State the limitations where we cannot use joiner in the mapping pipeline?

553


What are the informatica performance improvement tips

617