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.



No comments:

Post a Comment