PowerCenter - The Source Qualifier transformation

Card Puncher Data Processing

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.





Discover More
Powercenter Mapping Pass Through
PowerCenter - Mapping

Mapping depict the flow of data between source and targets. A Pass-Through mapping inserts all the source rows into the target. To create and edit mappings, you use the Mapping Designer tool in the...
Powercenter Pre Session Variable Assignment
PowerCenter - Mapping (Parameter|Variable)

When you use a mapping parameter or variable in a mapping, first you declare the mapping parameter or variable for use in each mapplet or mapping. Then, you define a value for the mapping parameter or...
Powercenter Workflow Manager Connections
PowerCenter - Source

A Source is : a database objects (table, views, synonyms) or files (xml, ...) that provide source data. PowerCenter accesses the following sources: Relational. Oracle, Sybase ASE, Informix,...
Powercenter Transformation Create
PowerCenter - Transformations

A transformation is a part of a mapping that generates or modifies data. Every mapping includes a Source Qualifier transformation, representing all data read from a source and temporarily stored by the...



Share this page:
Follow us:
Task Runner