Table of Contents


  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Creating a Mapping

Creating a Mapping

Create a mapping between a landing table and a staging table.
  1. In the
    workbench, click
  2. Acquire a write lock.
  3. Right-click in the mappings area and select
    Add Mapping
    The Mappings tool displays the Mapping dialog box.
  4. Specify the mapping properties.
    Name of the mapping as it will be displayed in the
    Hub Console
    Description of the mapping.
    Landing Table
    Select the landing table that will be the
    of the mapping.
    Staging Table
    Select the staging table that will be the
    of the mapping.
    Secure Resource
    Enable to make the mapping a secure resource, which allows you to control access to the mapping. After a mapping is designated as a secure resource, you can assign privileges to it in the Secure Resources tool.
    The following image shows a sample mapping:
    The sample mapping is called IDD Party. The mapping has a landing table called LDG Party and a staging table called IDD Party.
  5. Click
  6. Click the
    The Mappings tool displays the landing table and staging table on the workspace.
  7. To map columns with the same name from the landing table to the staging table, click the
    Auto mapping
    The following image shows the results of automapping on the sample mapping. You can change the connections:
    In the Diagram workspace, the columns with the same name are connected.
  8. Click
    You have a basic mapping. Next, you map the primary key.


We’d like to hear from you!