What are the different types of transformations in Informatica?
List of Transformations in Informatica
- Source Qualifier Transformation.
- Aggregator Transformation.
- Router Transformation.
- Joiner transformation.
- Rank Transformation.
- Sequence Generator Transformation.
- Transaction Control Transformation.
- Lookup and Re-usable transformation.
What is difference between active and passive transformation in Informatica?
A transformation can be active or passive. An active transformation can change the number of rows that pass through the transformation. A passive transformation does not change the number of rows that pass through the transformation.
What is the difference between filter and expression transformation?
The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. Connect a router transformation to expression.
What is the difference between router and filter transformation?
Router transformation provides us the facility to capture the rows of data that do not meet any of the conditions to a default output group. A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. Filter is single input and single output group transformation.
What types of transformation ports are supported?
Table of Contents
- Active Transformations.
- Passive Transformations.
- Unconnected Transformations.
- Multi-Strategy Transformations.
- Transformation Descriptions.
Is update strategy an active transformation?
The Update Strategy Transformation in Informatica is an Active and Connected transformation. It is useful to update, insert, or delete the records in a target based on source table data. And the beauty of this transformation is: you can restrict the records from not reaching into the target table.
How many types of transformations are there?
There are four main types of transformations: translation, rotation, reflection and dilation.
What is expression transformation in Informatica with example?
The Expression transformation calculates values within a single row. Use the Expression transformation to perform non-aggregate calculations. For example, you might use an Expression transformation to adjust bonus percentages or to concatenate first and last names.
What is lookup transformation in Informatica?
The Lookup transformation returns the result of the lookup to the target or another transformation. You can configure the Lookup transformation to return a single row or multiple rows. When you configure the Lookup transformation to return a single row, the Lookup transformation is a passive transformation.
What are different ports in Informatica?
Application Services and Ports
| Type | Default Port |
|---|---|
| Informatica Administrator (HTTP) | 6008 |
| Informatica Administrator (HTTPS) | 8443 |
| Informatica Administrator shutdown | 6009 |
| Service Process (Minimum) | 6013 |
How many transformations are there in Informatica?
There are two types of transformations in Informatica that are active and passive. Let us have a look at these with examples. Transformations in Informatica with Examples. In Informatica, active transformations modify rows and number of input rows while passive ones do not change several input rows and no new rows are created or existing dropped.
What is Informatica data transormation tool?
Informatica Transformations are PowerCenter repository objects that generates, modifies and passes data . Transformation allows you to define business rules for processing data.
What is a filter transformation?
Filter transformation is an active, connected transformation. The filter transformation is used to filter out rows in a mapping.