PowerCenter - Mapping

Card Puncher Data Processing


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 designer.

The mapping interface in the Designer is component-based. You add transformation to a mapping that depict how the integration service extracts and transforms data before it loads a target. The only objects in a mapping that are not stored as independent repository objects are the non-reusable transformations that you build within the mapping. These non-reusable transformations are stored within the mapping only.

Every mapping includes a source qualifier transformation, representing all data read from a source and temporarily stored by the integration service. It represents the rows that the integration service reads from the source when it runs a session. One of its important property is the SQL query that Integration service fired against an relational data source.

Powercenter Mapping Pass Through

If you examine the mapping, you see that data flows from the source definition to the source qualifier transformation to the target definition through a series of input and output ports connected by links.

The source provides information, so it contains only output ports, one for each column. Each output port is connected to a corresponding input port in the source qualifier transformation. The Source Qualifier transformation contains both input and output ports. The target contains input ports.

You link mapping objects (such as source, transformation, target) through the ports where Data passes into and out.

Manage a mapping

Create a mapping

To create a new mapping:

  1. PowerCenter - Designer > Tools > Mapping Designer
  2. Click Mappings > Create.
  3. In the Mapping Name dialog box, enter m_NameOfTheMapping as the name of the mapping.

Validate a mapping

When you save changes to the repository, the PowerCenter - Designer validates the mapping.

Powercenter Mapping Validation Save Output

When you need to link ports with different names, you can drag from the port of one transformation to a port of another transformation or target. If you connect the wrong columns, select the link and press the Delete key.

When you drag ports from one transformation to another, the Designer copies the port description and links the original port to its copy.

From the Source Qualifier transformation, drag the column into the transformation. A copy of the source port now appears in the transformation. The new port has the same name and datatype as the port in the Source Qualifier transformation.

Every port you drag is copied, but not linked.

Documentation / Reference

Discover More
Powercenter Component
PowerCenter - Architecture/Components

Architecture for 8.x version of Informatica PowerCenter. PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store...
Card Puncher Data Processing
PowerCenter - Client

The PowerCenter Client consists of the following applications that you use to manage the repository, design mappings, mapplets, and create sessions to load the data: . Use the Designer to create mappings...
Powercenter Designer Tools
PowerCenter - Designer

The Designer has the following tools that you use to analyze sources, design target schemas, and build source-to-target mappings: . Import or create source definitions. . Import or create target definitions....
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. 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 Designer Tools
PowerCenter - Mapping Designer

Powercenter Mapping Designer is a component/tool of . Its aim is to create mapping that the integration service uses to extract, transform, and load data.
Card Puncher Data Processing
PowerCenter - Mapplet

A mapplet is a set of transformations that you: use in multiple mappings. design in mapplet designer
Powercenter Designer Tools
PowerCenter - Mapplet Designer

Powercenter Mapplet Designer is a component/tool of designer. Its aim is to create mapplets (sets of transformation) to use in mapping.
Powercenter Port
PowerCenter - Port

Data passes into and out of a mapping through the following ports: Input ports. Receive data. Output ports. Pass data. Input/output ports. Receive data and pass it unchanged. A set of ports...
Card Puncher Data Processing
PowerCenter - Repository Objects

You create repository objects using the and client tools. You can also view the objects in the Navigator window of the . source definitions. Definitions of database objects (table, views, synonyms)...

Share this page:
Follow us:
Task Runner