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

Using Multiple Columns as the Primary Key

Using Multiple Columns as the Primary Key

If the source data does not have a column with unique values, concatenate the values from multiple columns to form unique primary keys. Use a string concatenation function from MDM Hub or Informatica Data Quality, or create a custom function.
Ensure that you have the mapping open in the
Diagram
workspace.
Although more than three columns from the landing table can be mapped to the PKEY_SRC_OBJECT column in the staging table, index creation is restricted to a maximum of three columns.
  1. Identify the columns that you want to concatenate for the primary key.
  2. Add a concatenate function.
    1. In the
      Diagram
      workspace, right-click the workspace and select
      Add Function
      .
    2. Expand
      String Functions
      .
    3. Click
      Concatenate
      .
    4. Click
      OK
      .
    The concatenate function appears in the workspace.
  3. From the landing table, for each column that you want to concatenate, drag its output connector to an input connector on the concatenate function.
  4. From the function, drag the output connector to the input connector on the PKEY_SRC_OBJECT column in the staging table.
    The primary key connection is complete.
  5. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!