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

Delete a Relationship Example

Delete a Relationship Example

Your organization has the PARTY base object that contains a record for Mary Adam. The PARTY GROUP base object contains the details of the Adam household to which Mary belongs. The relationship between the PARTY and the PARTY GROUP base object is defined in the associated PARTY GROUP REL relationship base object. You need to delete the relationship between Mary and the Adam household that is effective from October 6, 2006.
You want to delete a version of Mary's relationship record that is incorrect. When you delete Mary's relationship record, the MDM Hub adds a record in the deleted state to the cross-reference table associated with the PARTY GROUP REL relationship base object.
The following changes occur in the cross-reference table, RL PARTY GROUP CROSS-REFERENCE, that is associated with the PARTY GROUP REL relationship base object:
  • A record is inserted for the relationship between Mary and the Adam household without any change to the effective period.
  • The deleted indicator of the new record is -999999999.
  • The hub state indicator of the new record is deleted.
  • The original record does not change.
Before you delete the relationship between Mary and the Adam household, the cross-reference table shows that the relationship is active.
Rowid XREF
Rowid Object
Party ID
Deleted Indicator
Hub State Indicator
Party Group ID
Period Start Date
Period End Date
63
22
147
Active
28
6 October 2006
31 December 2999
After you delete the relationship between Mary and the Adam household, the cross-reference table shows a new record with the relationship deleted.
Rowid XREF
Rowid Object
Party ID
Deleted Indicator
Hub State Indicator
Party Group ID
Period Start Date
Period End Date
63
22
147
Active
28
6 October 2006
31 December 2999
621
22
147
-999999999
Deleted
28
6 October 2006
31 December 2999
The relationship base object shows that the relationship between Mary and the Adam household is deleted.
Rowid Object
Party ID
Deleted Indicator
Hub State Indicator
Party Group ID
22
147
-999999999
-1
28

0 COMMENTS

We’d like to hear from you!