What is active and passive transformation?

Answer Posted / mln

Active transformations number of output rows will be lesser
than input rows.
and active transformations work at column level.

Is This Answer Correct ?    17 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers using expression transformation?

653


Differences between version 7.x and 8.x.

1433


Can you generate sequence numbers without using the sequence generator transformation?

607


Explain lookup transformation is active in informatica

671


What is persistent lookup cache?

612






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?

561


Differentiate between sessions and batches?

585


What is intricate mapping?

597


Which is the t/r that builts only single cache memory?

724


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

560


What is informatica? Why do we need it?

650


What is aggregator transformation in informatica?

553


What is a stored procedure transformation?

620


Where is metadata stored?

629


How to create the source and target database connections in server manager?

640