Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is rank transformation in informatica
define galaxy repository in informatica
Describe expression transformation?
Differentiate between joiner and lookup transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the new features of informatica 9.x in developer level?
Where are the source flat files kept before running the session?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the advantages of using informatica as an etl tool over teradata?
What is incremental aggregation?
Explain the scenario which compels informatica server to reject files?
Can we create multiple integration service on single repository?
In which transformation you cannot drag ports into it?
What is main use of mapplet?
How can informatica be used for an organization?
