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

Enabling Delta Detection for a Staging Table

Enabling Delta Detection for a Staging Table

To enable delta detection for a staging table:
  1. Start the Schema Manager.
  2. Select the staging table that you want to configure.
  3. Acquire a write lock.
  4. Select (check) the
    Enable delta detection
    check box to enable delta detection for the table. You might need to scroll down to see this option.
  5. Specify the manner in which you want to have deltas detected.
    Option
    Description
    Detect deltas by comparing all columns in mapping
    All columns are selected for delta comparison, including the Last Update Date.
    Detect deltas via a date column
    If your schema has an applicable date column, choose this option and select the date column you want to use for delta comparison. This is the preferred option in cases where you have an applicable date column.
  6. Specify whether to allow staging if a prior duplicate was rejected during the stage process or load process.
    • Select (check) this option to
      allow
      the duplicate record being staged, during this next stage process execution, to bypass delta detection if its previously-staged duplicate was rejected.
      If this option is enabled, and a user in the Batch Viewer clicks the
      Clear History
      button while the associated stage job is selected, then the history of the prior rejection (that this feature relies on) will be discarded because the records in the REJ table will be cleared the next time the stage job is run.
    • Clear (uncheck) this option (the default) to prevent the duplicate record being staged, during this next stage process execution, from bypassing delta detection if its previously-staged duplicate was rejected. Delta detection will filter out any corresponding duplicate landing record that is subsequently processed in the next stage process execution.

0 COMMENTS

We’d like to hear from you!