Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Setting Up Hard Delete Detection for Consensus Delete with End Date

Setting Up Hard Delete Detection for Consensus Delete with End Date

After you complete the general configuration to detect hard deletes, set up the procedure for consensus delete with an end date for a staging table.
  1. Configure the
    MDM Hub
    to detect hard deletes.
  2. Identify the stage jobs in which the
    MDM Hub
    must detect hard deletes.
  3. Insert the staging table details and other required metadata into the hard delete detection table.
  4. In the
    Schema
    tool, enable the
    Trust
    and
    Validate
    checkboxes for the column name that contains the value of the delete flag for any hard deleted records.
  5. If you use an end date, enable the
    Trust
    and
    Validate
    check boxes for the end date column name.
  6. In the
    Systems and Trust
    tool, specify trust settings for the delete flag column name, and the end date column name for each source system.
    The value for
    Decay
    must be the same for all source systems of the base object.
  7. In the
    Schema
    tool, set up validation rule for the delete flag column name for each base object that you configured for Hard Delete Detection. You must set the partial delete flag to a lower trust value than the active, or fully deleted flag.
    1. Select
      Validation Rules Setup
      for the base object.
      The
      Validation Rules
      page appears.
    2. Click the
      Add validation rule
      button.
      The
      Add Validation Rule
      dialog box appears.
    3. Enter a rule name and select the
      Custom
      rule type from the list.
      Note: Do not insert a comma into the rule name. This can disrupt the order of the validation rules.
    4. Select a downgrade percentage and specify a rule in the following format in the
      Rule SQL
      section:
      WHERE S.<
      Delete flag column name
      > LIKE '<
      Value of delete flag column for partial delete
      >'
      You must not enable
      Reserve Minimum Trust
      for the column.

0 COMMENTS

We’d like to hear from you!