Table of Contents

Search

  1. Version 10.3
  2. Version 10.2
  3. Version 10.1
  4. Version 10.0.0

Specifying Primary Key Columns for Hard Delete Detection

Specifying Primary Key Columns for Hard Delete Detection

When you create a unique primary key by concatenating values from multiple source columns, the hard delete detection (HDD) process looks at the inputs to the function and monitors all the input source columns. You can now override this behavior by listing the columns to monitor in the hard delete detection repository table.
For example, you create a custom function with many inputs. Within the custom function, some of the source columns are inputs to a concatenate function that creates the unique primary key. Other source columns pass through the custom function unchanged. The HDD process cannot see what happens within a custom function. Therefore, the HDD process monitors all the inputs to the custom function. You want the HDD process to monitor only the source columns that contribute to the primary key.
To focus the HDD process on the subset of source columns that contribute to the primary key, configure the C_REPOS_EXT_HARD_DEL_DETECT repository table. Add an HDD_LANDING_PKEY_COLUMNS column, and insert a comma-separated list of the column names.
For more information, see "Specifying the Primary Key Columns for Hard Delete Detection" in the
Informatica MDM Multidomain Edition Version 10.0.0 HotFix 3 Configuration Guide

0 COMMENTS

We’d like to hear from you!