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

Example

Example

Your organization has the CUSTOMER base object for which you enable timeline. The CUSTOMER base object contains a record for John Smith who lived in the city of Los Angeles effective 31 January 2011 to 20 October 2013, currently lives in San Francisco effective 21 October 2013, and will live in Las Vegas effective 25 November 2015. The
MDM Hub
tracks past, present, and future changes to data, such as the address of John Smith.

Record with Past Data

The CUSTOMER base object contains the record for John Smith with a Los Angeles address where he resided in the past. The cross-reference table contains the record of John Smith with the period between which he lived in Los Angeles.
The cross-reference record for John Smith shows that he lived in Los Angeles in the past.
Rowid XREF
Rowid Object
Customer ID
First Name
Last Name
City
Period Start date
Period End Date
1
2
25
John
Smith
Los Angeles
January 31, 2011
October 20, 2013
The base object record for John Smith displays the best version of the truth (BVT) for the effective date that you specify, such as 12 February 2012.
Rowid Object
Customer ID
First Name
Last Name
City
2
25
John
Smith
Los Angeles

Record with Past and Present Data

The CUSTOMER base object contains the record for John Smith with an address that is the BVT for the date that you specify. The cross-reference table contains a record for John Smith. The cross-reference table shows the period between which he lived in Los Angeles and a record with the period between which he lived in San Francisco.
The cross-reference record for John Smith shows that he lived in Los Angeles in the past.
Rowid XREF
Rowid Object
Customer ID
First Name
Last Name
City
Period Start date
Period End Date
1
2
25
John
Smith
Los Angeles
January 31, 2011
October 20, 2013
2
2
25
John
Smith
San Francisco
October 21, 2013
November 24, 2015
The base object record for John Smith displays the BVT for the period that you specify, such as 12 February 2012.
Rowid Object
Customer ID
First Name
Last Name
City
2
25
John
Smith
Los Angeles

Record with Past, Present, and Future Data

The CUSTOMER base object contains the record for John Smith with an address that is the BVT for the date that you specify. The cross-reference table contains the record of John Smith with the period for which he lived in Los Angeles.
The cross-reference records for John Smith, who lived in Los Angeles, lives in San Francisco, and will live in Las Vegas from 25 November 2015.
Rowid XREF
Rowid Object
Customer ID
First Name
Last Name
City
Period Start date
Period End Date
1
2
25
John
Smith
Los Angeles
January 31, 2011
October 20, 2013
2
2
25
John
Smith
San Francisco
October 21, 2013
November 24, 2015
3
2
25
John
Smith
Las Vegas
November 25, 2015
null
The base object record for John Smith displays the BVT for the period that you specify, such as 12 February 2012.
Rowid Object
Customer ID
First Name
Last Name
City
2
25
John
Smith
Los Angeles

0 COMMENTS

We’d like to hear from you!