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

Update a System Column of a Relationship Record Example

Update a System Column of a Relationship Record Example

Your organization has the PARTY base object that contains the record for Mary Adam, and the record for the ABC organization. The relationship between Mary Adam and the ABC organization is defined in the associated PARTY REL relationship base object. You update the period start date and period end date.
You configured Informatica Data Director to use the IDD source system and the updates are performed in the Hierarchy view.
You update the period start date from
null
to
1 January 2016
and period end date from
null
to
1 January 2017
.

When Updates Are from the SFDC Source System

When the update to the period start date and the period end date is from an SFDC source system record, the MDM Hub updates the RL PARTY CROSS-REFERENCE table in the following ways:
  • The MDM Hub does not change the existing cross-reference records.
  • The MDM Hub inserts a new cross-reference record with the start date set to 1 January 2016 and the end date set to 1 January 2017.
The RL PARTY CROSS-REFERENCE table shows an active record for which you want to change the period start date and period end date.
Rowid System
Rowid Object
Party ID1
Party ID2
Hub State Indicator
Rel Desc
Period Start Date
Period End Date
SFDC
414722
2402007
2402147
Active
Individual
null
null
After you change the period start date and period end date, the RL PARTY CROSS-REFERENCE table shows the existing record and a new record.
Rowid System
Rowid Object
Party ID1
Party ID2
Hub State Indicator
Rel Desc
Period Start Date
Period End Date
SFDC
414722
2402007
2402147
Active
Individual
null
null
IDD
414722
2402007
2402147
Active
Individual
1 January 2016
1 January 2017

When Updates Are from the IDD Source System

When the update to the period start date and the period end date is from the IDD source system record, the MDM Hub updates the RL PARTY CROSS-REFERENCE table in the following ways:
  • The MDM Hub does not change the existing cross-reference records.
  • The MDM Hub inserts a new cross-reference record with the end date set to 31 December 2015.
  • The MDM Hub inserts a new cross-reference record with the start date set to 1 January 2016 and the end date set to 1 January 2017.
  • The MDM Hub inserts a new cross-reference record with the start date set to 2 January 2017 and the end date set to null.
The RL PARTY CROSS-REFERENCE table shows active records for which you want to change the period start date and period end date.
Rowid System
Rowid Object
Party ID1
Party ID2
Hub State Indicator
Rel Desc
Period Start Date
Period End Date
IDD
414722
2402007
2402147
Active
Individual
null
null
After you change the period start date and period end date, the RL PARTY CROSS-REFERENCE table shows the existing record and three new records.
Rowid System
Rowid Object
Party ID1
Party ID2
Hub State Indicator
Rel Desc
Period Start Date
Period End Date
IDD
414722
2402007
2402147
Active
Individual
null
null
IDD
414722
2402007
2402147
Active
Individual
null
31 December 2015
IDD
414722
2402007
2402147
Active
Individual
1 January 2016
1 January 2017
IDD
414722
2402007
2402147
Active
Individual
2 January 2017
null

0 COMMENTS

We’d like to hear from you!