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 All Relationship Periods Example

Delete All Relationship Periods 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.
You want to delete Mary's relationship record because her relationship with the Adam household is incorrect. You must delete all relationship record versions that are effective for different periods. When you delete Mary's relationship records for all effective periods, the MDM Hub changes the hub state of the record versions to the deleted state in the cross-reference table associated with the PARTY GROUP REL relationship base object.
When you delete all relationship periods, the hub state indicator of all the original record versions is set to deleted in the cross-reference table, RL PARTY GROUP CROSS-REFERENCE, that is associated with the PARTY GROUP REL relationship base object.
Before you delete all the relationship periods, the cross-reference table shows that all the effective relationships between Mary and the Adam household are active.
Rowid XREF
Rowid Object
Party ID
Hub State Indicator
Party Group ID
Period Start Date
Period End Date
63
22
147
Active
28
October 6, 2006
December 31, 2015
66
22
147
Active
28
January 1, 2016
December 31, 2999
After you delete all the relationship periods, the cross-reference table shows that all relationships between Mary and the Adam household are deleted.
Rowid XREF
Rowid Object
Party ID
Hub State Indicator
Party Group ID
Period Start Date
Period End Date
63
22
147
Deleted
28
October 6, 2006
December 31, 2015
66
22
147
Deleted
28
January 1, 2016
December 31, 2999
The relationship base object shows that the relationship between Mary and the Adam household is deleted.
Rowid Object
Party ID
Hub State Indicator
Party Group ID
22
147
-1
28

0 COMMENTS

We’d like to hear from you!