Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Multidomain MDM 10.4
  • All Products

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

Configuration Guide

Configuration Guide

Back Next

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!