Informatica Mapping

Informatica Mapping represents the data flow between the Source and target tables or we can simply say that, it defines the rules for data Transformation. In order to create Informatica Mapping, we require one or more Source Definitions, one or more Target definitions and Transformations. Following screenshot will show you the diagrammatic representation of the same.

From the above screenshot you can observe that, Every mapping should contain the following components:

• Source Definition: Here, we are going to use one or more sources that we created in source analyzer. Please refer the Informatica Source Analyzer article to understand its functionality.
• Transformations: Modifies the source data using different types of available transformations.
• Target Definition: Here, we are going to use one or more targets that we created in target designer. Please refer the Target Designer in Informatica article to understand its functionality.

Informatica Mapping Designer

Before we start doing anything, First connect to Informatica repository service. In order to connect with Repository service we have to provide the Informatica Admin Console credentials so, Please provide the appropriate Username and Password and click on Connect button as shown below.

TIP: Here you have to provide the Admin Username and password that you specified while installing the Informatica Server.

Once you connected successfully, Please navigate to Tools menu in Menu Bar. Following screenshot will show the list of available tools inside the Informatica PowerCenter Designer. In this article we are explaining about the Informatica Mapping so, please select the Mapping Designer option.

Once you select the Mapping Designer option, we will be in the Mapping Designer screen as shown below.

TIP: Mapping Menu in the Menu bar will be available only when you are in Mapping Designer section otherwise, it will be hidden.

STEP 1: In order to create new mapping, Please navigate to Mappings menu in Menu Bar and select the Create.. option. This will open the Mapping Name window as shown below. Here, you have to write unique name for this mapping and click OK button.

STEP 2: Drag and drop the DimProducts source definition from Sources folder to the mapping designer. Once you drag the source, PowerCenter designer will automatically create the default transformation called source qualifier.

STEP 3: Drag and drop the Target_DimProducts target definition from Targets folder to the mapping designer as shown below.

TIP: Generally, we place one or more transformations in between the Source definition and the target definition and we will cover them in coming tutorials.

STEP 4: We have to connect the source qualifier with the target definition. Informatica PowerCenter Designer provides multiple ways to connect them and the first approach is, Right click on the empty space present in mapping designer will open the following context menu. Please select the Autolink.. option from that context menu.

Second approach is selecting all columns present in Source Qualifier and dragging them to the target definition. In both these approaches, if there is any mismatch in the column names then we have to attach them manually.

From the below screenshot you can observe that, we have Size column in source and Size_FLD in target. In these situations, Auto link or dragging columns will not link them. So, please select the required column (Size) and drag it to the destination column (Size_FLD) to create the connection.

NOTE: Informatica Mapping designer allows us to delete the wrong mapping by selecting the link and deleting it.

STEP 5: Let us validate the mapping by going to Mapping Menu bar and selecting the Validate option as shown below.

Thank You for Visiting Our Blog