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
What is a node in Informatica?
Explain target update override in informatica
What are the types of caches in lookup? Explain them.
Explain in detail scd type 2 through mapping.
What is different between the data warehouse and data mart?
What are some examples of informatica etl programs?
What are junk dimensions?
What is mapplet in informatica?
Is there any way to read the ms excel datas directly into informatica?
can u any challenge your project?
Write the prerequisite tasks to achieve the session partition?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
waht type of interface is used for testing the data in informatica
Differentiate between a database and data warehouse?
How can a transformation be made reusable?