About

Every mapping that need to read data from relational or flat file sources, includes a Source Qualifier transformation, representing all data read from the source and temporarily stored by the integration service.

Powercenter Mapping Pass Through

The source qualifier represents the rows that the integration service reads from the source when it runs a session.

When the source is a database, you will find on this transformation the SQL query.

Powercenter Session Source Qualifier Attribute The SQL query and other attributes can be override by the session attributes when the mapping is run.

Performance

Powercenter Transformation Source Qualifier Single

When you create a single Source Qualifier transformation, the PowerCenter - Integration Service increases performance with a single read on the source database instead of multiple reads.