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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

History Tables

History Tables

History tables reside in the
Hub Store
.
If you enable history for a base object,
Informatica MDM Hub
maintains history tables for the base objects and cross-reference tables.
Informatica MDM Hub
provides detailed change-tracking options, such as merge and unmerge history, history of the pre-cleansed data, history of the base object, and the cross-reference history in history tables.
When you run an automerge job, the
Informatica MDM Hub
creates a record in the history table for each merge operation. Similarly, each time the
Informatica MDM Hub
updates a foreign key in a child base object, a record is inserted in the corresponding history table.

Base Object History Tables

A history-enabled base object has a single history table (named C_
baseObjectName
_HIST) that contains historical information about data changes in the base object. Whenever a record is added or updated in the base object, a new record is inserted into the base object history table to capture the event.

Cross-Reference History Tables

A history-enabled base object has a single cross-reference history table (named C_
baseObjectName
_HXRF) that contains historical information about data changes in the cross-reference table. Whenever a record changes in the cross-reference table, a new record is inserted into the cross-reference history table to capture the event.

0 COMMENTS

We’d like to hear from you!