How can you define a transformation? What are different
types of transformations in Informatica?

Answer Posted / bobby

Transformation allow you to define transformation rules i.e.
business logic used for processing data.
There are 2 types of transformation they are:-
1.Active transformation
2.Passive transformation
1.Active transformation :- The number of rows which enter
the transformation is not same as number of rows exit the
transformation i.e chages occur.
2.Passive transformation :-The number of rows which enter
the transformation is same as number of rows exit the
transformation i.e chages does not occur.

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of aggregator transformation?

582


Enterprise data warehouse your projects phase by phase explain?

1474


list out all the transformations which use cache?

693


what is SDLC way of code development?

1566


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

607






What is the commit type if you have a transaction control transformation in the mapping?

656


What is meant by LDAP users?

699


How to do unit testing in informatica?

728


How can we use batches?

606


Explain the aggregator transformation?

631


Explain transaction control transformation in informatica

763


What is the fact table?

595


What is lookup transformation?

605


What is the difference between stop and abort in informatica

666


What is sq transformation?

670