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
Which is the t/r that builts only single cache memory?
Explain dynamic target flat file name generation in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to handle decimal places while importing a flatfile into informatica?
What is a repository? And how to add it in an informatica client?
Can informatica load heterogeneous targets from heterogeneous sources?
What does command task mean?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what are the deliverables?in your project?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a sorter transformation?
can we override a native sql query within informatica? Where do we do it?
What is a connected transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
