Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Update a Custom Column of a Relationship Record Example

Update a Custom 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 value in the Rel Desc column, which is a custom column, from
Individual
to
Organization
.
You configured Informatica Data Director to use the IDD source system and the updates are performed in the Hierarchy view.

When Updates Are from the SFDC Source System

When the update to the Rel Desc column is from a 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 record.
  • The MDM Hub inserts a new cross-reference record with no change to the start date and end date.
  • The MDM Hub updates the values of the custom column and the Rowid System column in the new cross-reference record with values from the contributing source system.
The RL PARTY CROSS-REFERENCE table shows a record for which you want to change the value of the Rel Desc custom column.
Rowid System
Rowid Object
Party ID1
Party ID2
Rel Desc
Period Start Date
Period End Date
SFDC
414722
2402007
2402147
Individual
null
null
After you change the value of the Rel Desc column from
Individual
to
Organization
, the RL PARTY CROSS-REFERENCE table shows the existing record and a new one.
Rowid System
Rowid Object
Party ID1
Party ID2
Rel Desc
Period Start Date
Period End Date
SFDC
414722
2402007
2402147
Individual
null
null
IDD
414722
2402007
2402147
Organization
null
null

When Updates Are from the IDD Source System

When the update to the Rel Desc column is from a record that is from the IDD source system, the MDM Hub updates the RL PARTY CROSS-REFERENCE table in the following ways:
  • The MDM Hub updates the value of the custom column in the existing cross-reference record.
  • The MDM Hub does not change the start date and end date of the cross-reference record.
The RL PARTY CROSS-REFERENCE table shows the record for which you want to change the value of the Rel Desc custom column.
Rowid System
Rowid Object
Party ID1
Party ID2
Rel Desc
Period Start Date
Period End Date
IDD
414722
2402007
2402147
Individual
null
null
After you change the value of the Rel Desc column from
Individual
to
Organization
, the RL PARTY CROSS-REFERENCE table shows the updated record.
Rowid System
Rowid Object
Party ID1
Party ID2
Rel Desc
Period Start Date
Period End Date
IDD
414722
2402007
2402147
Organization
null
null

0 COMMENTS

We’d like to hear from you!