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
write a query to retrieve the latest records from the table sorted by version(scd)
Explain about Informatica server process that how it works relates to mapping variables?
what is $$$$?
Why do you use Mapping Parameter and mapping variable?
What is difference between a gateway node and worker node?
Where is metadata stored?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
In informatics server which files are created during the session rums?
What is the need of an ETL tool?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
can you please explain me pre session and post session options?
What are active and passive transformations?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Separate from an archive server and a powerhouse?
Global and Local shortcuts. Advantages.