Configuration Guide

10.3 HotFix 3
- 10.5 HotFix 2
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

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

1 January 2016

and period end date from

null

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

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Update a System Column of a Relationship Record Example

Update a System Column of a Relationship Record Example

When Updates Are from the SFDC Source System

When Updates Are from the IDD Source System