Basic Informatica Tutorial

Normalizer Transformation is Active and Connected transformation. It converts single row data into multiple columns data. It converts de-no...

Stored Procedure Transformation is Passive transformation.  It is both connected and unconnected. Procedure are stored in database and we...

Union Transformation is Connected and Active transformation.  It is used when we have requirement like multiple input groups but only 1 ou...

Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...

Sorter Transformation is Connected and Active transformation. It is use to sort the data either in ascending order or descending order by s...

Source Qualifier Transformation is Connected and Active transformation. When ever we drag our source to mapping area by default source qual...

Sequence Generator  Transformation  is Connected and Passive Transformation. It is used to generate the sequence numbers of our choice. If ...

Router transformation is an active and connected transformation. It is an extension of the filter transformation. Here in the router, we can...

Rank Transformation is Active and Connected Transformation. It is used to rank the list of the records in a table. We can rank top and bott...

Lookup Transformation is both connected and unconnected. Lookup Transformation is both active and passive.  From Informatica PowerCenter...

Joiner transformation is Connected and Active transformation. It is used to join the two tables or more tables from heterogeneous sources o...

Filter transformation is connected and active transformation. It is used to filter out the unwanted rows from loading into our target. In o...

Aggregator Transformation is connected and active transformation used to perform calculations. Aggregate calculations means sums, averages,...

Its the first and basic transformation used in Informatica power center tool. Expression transformation is connected and Passive transforma...