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

Enabling Delta Detection on Specific Columns

Enabling Delta Detection on Specific Columns

To enable delta detection for specific columns:
  1. Start the Schema Manager.
  2. Acquire a write lock.
  3. Select the staging table that you want to configure.
    The Staging Table Properties pane is displayed.
  4. Select the
    Enable delta detection
    check box.
  5. Select the
    Detect deltas using specific columns
    A list of available columns is displayed.
  6. Choose the columns that you want to use for delta detection and click
    Add >
    , or click
    Add All >>
    to add all the columns for delta detection.
When loading data to the staging table, if any column from the defined set has values different from the available previous load values, the row is treated as changed. If all columns from defined set are the same, the row is treated as unchanged. Columns that are not mapped are ignored.


We’d like to hear from you!