Tutorial Gateway

  • C Programming
  • Java
  • R
  • SQL
  • MySQL
  • Python
  • BI Tools
    • Informatica
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • QlikView
  • About
    • About Us
    • Contact Us

Informatica Mapping

12-01-2016 by suresh Leave a Comment

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.

Informatica Mapping 0

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.

Informatica Mapping 9

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.

Informatica Mapping 10

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.

Informatica Mapping 1

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.

Informatica Mapping 2

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.

Informatica Mapping 3

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.

Informatica Mapping 4

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.

Informatica Mapping 5

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.

Informatica Mapping 6

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.

Informatica Mapping 7

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

Informatica Mapping 8

Thank You for Visiting Our Blog

Placed Under: Informatica

Share your Feedback, or Code!! Cancel reply

Trending

  • SQL Server Integration Services (SSIS)
  • SQL Server Tutorial
  • C Program to Print Prime Numbers from 1 to 100
  • C Program to Calculate the Sum and Average of n Number
  • SQL Server Reporting Services (SSRS)
  • Home
  • Types of Functions in C

Stay in Touch!

Sign Up to receive Email updates on Latest Tutorials

  • Blogger
  • C Programs
  • Java Programs
  • SQL
  • SSIS
  • SSRS
  • Tableau
  • JavaScript

Copyright © 2018 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy