Transformations Overview:
A transformation is a repository object that can be generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.
Note: Transformation may be unconnected like Store Procedure, Un-Connected Lookup.
Source Qualifier:
Aggregator:
Application Source Qualifier:
Lookup:
Rank:
Router:
Sequence Generator:
Sorter:
Sorter is a Active/Connected transformation. It Sorts data based on a sort key.
Union:
Union is a Active/Connected transformation. It Merges data from different databases or flat file systems.
XML:
XMLGenerator is a Active/Connected transformation. It Reads data from one or more input ports and outputs XML through a single output port.
Transformations in a mapping represent the operations the Integration Service performs on the data. Data passes through transformation ports that you link in a mapping or mapplet.
Transformations can be active or passive. Transformations can be connected to the data flow, or they can be unconnected.
Active: A transformation that can Change the number of rows that pass through the transformation
Note: Transformation may be unconnected like Store Procedure, Un-Connected Lookup.
List of Transformation and its Descriptions:
Source Qualifier:
Source Qualifier is a Active/Connected transformation. It Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.
Aggregator:
Aggregator is an Active/Connected transformation. It Performs aggregate calculations like Sum, Max, Min, Avg, Count,..etc.
Application Source Qualifier:
Application Source Qualifier is Active/Connected transformation. Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.
Expression is Passive/Connected transformation. It Calculates a value in a single row.
Filter is Active/Connected transformation. It Filters data.
Joiner is a Active/Connected transformation. It Joins data from different databases or flat file systems.
Lookup:
Lookup is a Active or Passive/Connected or Unconnected transformation. It Look up and return data from a flat file, relational table, view, or synonym.
Normalizer is a Active/Connected transformation. It is used as Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
Rank:
Rank is a Active/Connected transformation. It limits records to a top or bottom range.
Router:
Router is a Active/Connected transformation. It Routes data into multiple transformations based on group conditions.
Sequence Generator:
Sequence Generator is a Passive/Connected transformation. It Generates primary keys.
Sorter:
Sorter is a Active/Connected transformation. It Sorts data based on a sort key.
SQL:
SQL is a Active or Passive/Connected transformation. It Executes SQL queries against a database.
Stored Procedure is a Passive/Connected or Unconnected transformation. It Calls a stored procedure.
Transaction Control is a Active/Connected transformation. It defines commit and rollback transactions.
Union:
Union is a Active/Connected transformation. It Merges data from different databases or flat file systems.
Update Strategy is a Active/Connected transformation. It Determines whether to insert, delete, update, or reject rows.
XML:
XMLGenerator is a Active/Connected transformation. It Reads data from one or more input ports and outputs XML through a single output port.
XMLParser is a Active/Connected transformation. It Reads XML from one input port and outputs data to one or more output ports.
XML Source Qualifier is a Active/Connected transformation. It Represents the rows that the Integration Service reads from an XML source when it runs a sessio
No comments:
Post a Comment