Answer Posted / mayank jhawar
Active Transformation -
An Active transformation can change teh number of rows that
pass through it from source to traget. It eliminates rows
that do not meet the condition in transformation.
Passive Transformation -A Passive transformation does not
change teh number of rows that pass through it i.e., it
passes all rows through the transformation.
List of transformations coming under Active transformations
are -
Source Qualifier Transformation
Aggregator Transformation
Filter Transformation
Rank Transformation
Joiner Transformation
Router Transformation
Normalizer Transformation
Update strategy Transformation
Sorter Transformation
ERP Source Qualifier Transformation
Advanced External Procedure Transformation
Look Up (now it is an active transformation)
And here find the Passive Transformations list -
Expression Transformation
Sequence Generatoe Transformation
LookUP Transformation (till Informatica Version9.0)
Stored Procedure Transformation
XML Source Qualifier Transformation
External procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Could you explain what is enterprise data warehouse?
what is the difference between informatica6.1 and infomatica7.1
How can we use batches?
What is the difference between informatics 7x and 8x and what is latest version?
Explain the shared cache and re-cache?
Explain about Informatica server process that how it works relates to mapping variables?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is data caches/ index caches?
What is rank transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is xml source qualifier transformation in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
In informatica workflow manager, how many repositories can be created?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the need for an etl tool?