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 do mean by local and global repository?
what is degenerated dimension?
what is the size of your data warehousing?
What is the way to execute pl/sql script using informatica mapping?
What is the need of etl tools?
Explain direct and indirect flat file loading (source file type) - informatica
What is a grid in Informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Briefly explain the aggregator transformation?
What are the mapping parameters and mapping variables?
whats the logic to load the lower level of granularity of data to fact table.
How can a transformation be made reusable?
What is the session task and command task?
lookup transformation with screenshots
What is a sorter transformation?