Table of Contents

Search

  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

Configure a Mapping

Configure a Mapping

You need to create a mapping with source, target, and transformation objects. After you add the mapping objects, you need to link the ports between mapping objects. Finally, validate the mappings.
  1. Create a mapping to transform data and load it into the staging tables.
    1. Select a project or folder in the
      Object Explorer
      view.
    2. Click
      File
      New
      Mapping
      .
      The following image shows the Mapping dialog box with the Name and Location fields:
      The Mapping dialog box with the Name and Location fields.
    3. Enter a mapping name.
    4. Click
      Finish.
      An empty mapping appears in the editor.
      The following image shows the Mapping_C_S_CRM_CUST empty mapping:
      The Mapping_C_S_CRM_CUST empty mapping.
  2. Add objects to the mapping to determine the data flow between sources and targets.
    1. Drag the physical data object that you created for the source to the editor and select
      Read
      to add the data object as a source.
    2. Drag the logical data object that represents the staging table to the editor and select
      Write
      to add the data object as a target.
      The following image shows the Mapping_C_S_CRM_CUST mapping with a physical data object and a logical data object:
      The Mapping_C_S_CRM_CUST mapping with a physical data object and a logical data object.
  3. Link ports between mapping objects.
    You can manually link ports or link ports automatically.
    After you edit, add, or delete a staging table column and synchronize the Model repository with the Hub Store, the corresponding mapplet ports are disconnected. You must manually connect the affected ports.
    The following image shows the Mapping_C_S_CRM_CUST mapping with links between the physical data object and the logical data object:
    The Mapping_C_S_CRM_CUST mapping with links between the physical data object and the logical data object.
  4. Validate a mapping to ensure that the Data Integration Service can read and process the entire mapping.
    1. Click
      Edit
      Validate
      .
      Errors might appear in the Validation Log view.
    2. Fix errors and validate the mapping again.

0 COMMENTS

We’d like to hear from you!