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

Update Record Data Example

Update Record Data 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 to 15 January 2015. You want to update the city that he lives in to Newark.
Before the data update, the cross-reference record for John Smith 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 data update, the cross-reference record for John Smith shows that he lives in Newark.
Rowid XREF
Rowid Object
Customer ID
First Name
Last Name
City
Period Start date
Period End Date
1
2
25
John
Smith
Newark
March 21, 2014
January 15, 2015
The
MDM Hub
updates the existing record version with the correct city name, Newark. The effective period for the record of John Smith does not change.

0 COMMENTS

We’d like to hear from you!