Informatica PowerCenter Common Conversion Components list

Conversion (transformation) is a database object that generates, modifies, or passes data. Equivalent to encapsulating functions, using input and output ports for data conversion operations.

Conversion type

Active conversion (Active): You can change the number of rows of data passed through it, such as the "filter" component, where the amount of data entered is different from the output.

Passive conversion (Passive): You cannot change the number of rows of data passed through it, such as the expression component, as the amount of data entered is the same as the output.

Connected (Connected): The transformation component is connected to the data flow, or it can be disconnected.

Not connected (unconnected): a non-connected transformation will not connect to another transformation in the map, it is called in another transformation and returns a value to the transformation.

Various conversion component functions (UPDATE_TIME:2016/08/10)

Icon	Component Name	Conversion type	Function	Detailed Introduction
	Updating policy (Update strategy)	active/ Connected	Determines whether rows are inserted, deleted, updated, or rejected.
	Application Resource Qualifier (application Source Qualifier)	active/ Connected	Represents a row that PowerCenter Server reads from an application (such as an ERP source) when it runs a session.
	Customization (Custom)	Active or passive/ Connected	Call a procedure in a shared library or DLL.
	Expressions (expression)	passive/ Connected	Calculate the value.
	External process (External Procedure)	passive/ Connected or unconnected	Call a procedure in a shared library or Windows COM layer.
	Filters (Filter)	active/ Connected	Filter the data.
	Inputs (input)	active/ Connected	Defines the mapping component input rows. Provided by Mapplet Designer.
	Connection (Joiner)	active/ Connected	Joins data from different databases or flat file systems.
	Find (Lookup)	passive/ Connected or unconnected	The lookup value.
	Canonicalization (Normalizer)	active/ Connected	The source qualifier used for the COBOL source. It can also be used in pipelines to normalize data in a relational source or flat file source.
	Outputs (output)	passive/ Connected	Defines the map component output line. Provided by Mapplet Designer.
	Rank (rank)	active/ Connected	Limit records to the top or bottom range.
	Router (Router)	active/ Connected	Sends data to multiple transformations based on group criteria.
	Sequence Generator (Sequence Generator)	passive/ Connected	Generates a primary key.
	Sequencer (Sorter)	active/ Connected	Sorts the data according to the sort key.
	Source Qualifier (Qualifier)	active/ Connected	Represents a row that PowerCenter Server reads from a relational source or flat file source when it runs a session.
	Stored Procedures (Stored Procedure)	passive/ Connected or unconnected	Call the stored procedure.
	Transaction controls (Transaction control)	active/ Connected	Defines the commit and rollback transactions.
	Union (Union)	active/ Connected	Merge data from different databases or flat file systems.
	Aggregation (aggregator)	active/ Connected	Performs an aggregation calculation. (avg (), Max () ... ）
	XML generator (XML Generator)	active/ Connected	Reads data from one or more input ports and then outputs the XML through a single output port.
	XML parser (XML Parser)	active/ Connected	Reads the XML from an input port and then outputs the data to one or more output ports.
	XML source Qualifier (XML Qualifier)	active/ Connected	Represents the rows that PowerCenter Server reads from the XML source while the session is running.
	HTTP conversion (HTTP transformation)	passive/connected	Connect to the HTTP server to read the updated data.
	Java	Active/passive Connected	Executes user-defined logic Java code. The bytecode will be stored in the repository.
	Sql	Active or passive/connected	Perform various SQL query operations on the database.

Informatica PowerCenter Common Conversion Components list