Configuration Guide

10.5 HotFix 2

Back Next

Batch Load of Multiple Record Versions Example

Your organization has the CUSTOMER base object for which you track data change events. The CUSTOMER base object contains a record for John Smith who lives in New York effective 21 March 2014 and will be in New York until 15 January 2015. You want to load record versions for other effective periods in the past and in the future.

You want to load records with the following effective periods from the staging table into the cross-reference table associated with the CUSTOMER base object:

31 January 2011 to 20 October 2013

21 October 2013 to 20 March 2014

16 January 2015 to 24 November 2015

25 November 2015 to null

To load multiple versions of records in a single load batch job, configure contiguity of effective periods of records in the base object. Also, you enable the

MDM Hub

to load record versions in a sequence that maintains contiguity with the existing record versions.

Before the load batch job, the cross-reference has one record for John Smith that shows that he lives in New York.

Rowid XREF	Rowid Object	Customer ID	First Name	Last Name	City	Period Start date	Period End Date
1	2	25	John	Smith	New York	March 21, 2014	January 15, 2015

After the load batch job, the cross-reference table has multiple, contiguous record versions for John Smith.

Rowid XREF	Rowid Object	Customer ID	First Name	Last Name	City	Period Start date	Period End Date
3	2	25	John	Smith	Los Angeles	January 31, 2011	October 20, 2013
2	2	25	John	Smith	San Francisco	October 21, 2013	March 20, 2014
1	2	25	John	Smith	New York	March 21, 2014	January 15, 2015
4	2	25	John	Smith	Austin	January 16, 2015	November 24, 2015
5	2	25	John	Smith	Las Vegas	November 25, 2015	null

The record shows that John Smith lived at Los Angeles and San Francisco, lives at New York, and will live in Austin and Las Vegas after the multiple versions of the record are loaded.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Batch Load of Multiple Record Versions Example

Batch Load of Multiple Record Versions Example