Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Batch Load of Multiple Record Versions Example

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.

0 COMMENTS

We’d like to hear from you!