Types of Transformations in Informatica
Our Informatica Training in Chennai is offering various facilities to get knowledge about the concepts of Informatica. We are also offering great works with experienced faculties. Informatica training is now explaining about some of the important different types of transformations in Informatica.
- Expression transformation
It is used to calculate values in a single row before we writing the target. You can also use this transformation to perform any non-aggregate calculations as well as to test conditional statements.There are 3 types of ports in this transformation they are Input,output and variable.
- Filter transformation
You can filter rows in a mapping through filter transformation. You can pass all the rows from the source transformation to filter transformation through filter condition. If the condition meets only it will passes through the filter transformation.
- Router transformation
It is similar to filter transformation because it also allows user to test condition of data. This router transformation is used to test condition more than once and it also checks rows of data even it is not satisfying the condition.
- Sorter transformation
It allow us to sort data, you can sort the data either in a ascending order or descending order in a specified sort key. It also checks case sensitive sorting as well as specify whether output rows are distinct. This sorter transformation contains only input and output keys. All information are sorted according to the sorting key.
- Rank transformation
It allows us to select a group of value either top values or bottom values, it is not just one value. During this interval power center server caches input data until it performs rank calculations.
- SQL transformation
You will be allowed to pass the database connection information to SQL transformation as input data during run time. This transformation process the query, return rows and database errors. Thus SQL transformation follows two types of mode, script mode and query mode.