Configuration Guide

10.5 HotFix 2

Back Next

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.

Identify the columns that you want to concatenate for the primary key.

Add a concatenate function.

In the

Diagram

workspace, right-click the workspace and select

Add Function

Expand

String Functions

Click

Concatenate

Click

The concatenate function appears in the workspace.