Configuration Guide

10.3 HotFix 3

Back Next

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

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

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

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

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Update a Custom Column of a Relationship Record Example

Update a Custom Column of a Relationship Record Example

When Updates Are from the SFDC Source System

When Updates Are from the IDD Source System