Brief and Simplified explanation of terminologies used in Informatica Power Center tool :-
Source : It is the place from where we import the data for the ETL process.
Target : It is the place where we load the data for analytical purpose.
Transformation : It is database object used to create, modify and pass the data.
A transformation consists of input ports and output ports. Transformation allows or passes number of rows that pass through it. Based on the output transformations are divided into two types. They are Active and Passive.
Source : It is the place from where we import the data for the ETL process.
Target : It is the place where we load the data for analytical purpose.
Transformation : It is database object used to create, modify and pass the data.
A transformation consists of input ports and output ports. Transformation allows or passes number of rows that pass through it. Based on the output transformations are divided into two types. They are Active and Passive.
List of Active Transformations :
--------------------------------------
Source Qualifier Transformation
Sorter Transformations
Aggregator Transformations
Filter Transformation
Union Transformation
Joiner Transformation
Normalizer Transformation
Rank Transformation
Router Transformation
Update Strategy Transformation
Advanced External Procedure Transformation
List of Passive Transformations :
--------------------------------------
Expression Transformation
Sequence Generator Transformation
Lookup Transformation
Stored Procedure Transformation
XML Source Qualifier Transformation
External Procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)
Why a transformation is said to be Active or Passive Transformation?
- Active transformation changes no of rows pass through it where as passive transformation
does not.
- Active transformation changes row type and passive does not change.
Update Strategy Transformation
- Active transformation changes transaction boundary and passive does not change it.
Transaction Control Transformation
Workflow : It is combination of various tasks connected with links.
Mapplet : If we want to apply a particular logic in a mapping and use it over again and again then we use mapplet.
Connected Transformation : When a series of transformations when connected with each other in a mapping is called connected transformation.
Unconnected Transformation : When a transformation is not connected with the series of connected transfomations then its called as unconnected transformation.
No comments:
Post a Comment