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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

End a Relationship Example

End 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 relationship base object PARTY GROUP REL. On May 17, 2015, Mary informs you that she is not a part of the Adam household anymore. You need to update Mary's record to end the relationship with the Adam household.
You set an end date for Mary's relationship with the Adam household. When you set an end date for Mary's relationship record, the MDM Hub adds a record in the deleted state to the cross-reference table associated with the relationship base object, RL PARTY GROUP CROSS-REFERENCE.
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.
  • The record is effective from May 18, 2015.
  • The deleted indicator is set to -999999999.
  • The hub state indicator is set to deleted.
  • The end date of the original record is updated to May 17, 2015.
Before you end Mary's relationship with the Adam household, the cross-reference table shows a record that is effective from October 6, 2006 to December 31, 2999.
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
October 6, 2006
December 31, 2999
After you end Mary's relationship with the Adam household, the cross-reference table shows that starting May 18, 2015, Mary is not a member of the Adam household.
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
October 6, 2006
May 17, 2015
621
22
147
-999999999
Deleted
28
May 18, 2015

0 COMMENTS

We’d like to hear from you!