Course Fees and Discounts
Quick Enquiry

Contact me

captcha

Blog

Types of Transformations in Informatica

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.

This entry was posted in Informatica and tagged , , on by .

Leave a Reply

Your email address will not be published. Required fields are marked *

ninety three − = eighty six

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>