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

Add a Record Version Example

Add a Record Version 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. You want to maintain contiguity of effective periods. You load a record version that is effective from 1 December 2014.
Before you load a new record version, the record for John Smith shows that he lives in New York from 21 March 2014.
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
null
When you load the record version that is effective from 1 December 2014, the effective period of the adjacent record version decreases. The MDM Hub adjusts the effective end date of the existing record to avoid the overlap of record versions and to maintain contiguity.
After you load the record version that is effective from 1 December 2014, the cross-reference table shows that the existing record version for John Smith ends on 30 November 2014.
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
November 30, 2014
2
2
25
John
Smith
Los Angeles
December 1, 2014
null

0 COMMENTS

We’d like to hear from you!