Showing posts with label Informatica Transformations. Show all posts
Showing posts with label Informatica Transformations. Show all posts

Thursday, February 25, 2016

Informatica Transformations Explained In Simple Way

Transformations


Transformation
Type
Description
1.Aggregator
Active/Connected
Performs aggregate calculations.
2.Expression
Passive/Connected
Calculates a value.
3.Filter
Active/Connected
Filters data.
4.Input(Mapplet)
Passive/Connected
Defines mapplet input rows. Available in the Mapplet Designer.
5.Joiner
Active/Connected
Joins data from different databases or flat file systems.
6.Lookup
Active or Passive/Connected or Unconnected
Look up and return data from a flat file, relational table, view, or synonym.
7.Normalizer
Active/Connected
Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
8.Output(Mapplet)
Passive/Connected
Defines mapplet output rows. Available in the Mapplet Designer.
9.Rank
Active/Connected
Limits records to a top or bottom range.
10.Router
Active/Connected
Routes data into multiple transformations based on group conditions.
11.Sequence Generator
Passive/Connected
Generates primary /Surrogate keys.
12.Sorter
Active/Connected
Sorts data based on a sort key.
13.Source Qualifier
Active/Connected
Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.
14.Stored Procedure
Passive/Connected or Unconnected
Calls a stored procedure.
15.Union
Active/Connected
Merges data from different databases or flat file systems.
16.Update Strategy
Active/Connected
Determines whether to insert, delete, update, or reject rows.
17.XML Source Qualifier
Active/Connected
Represents the rows that the Integration Service reads from an XML source when it runs a session.