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

Loading by Row ID

Loading by Row ID

You can configure load by row ID for the
Informatica MDM Hub
to streamline load, match, and merge processing.
When you configure the stage process, you need to map the landing table columns to the staging table columns. To configure load by row ID, map the landing table column that contains ROWID_OBJECT values to the ROWID_OBJECT column in a staging table. For example, you can provide ROWID_OBJECT values to the MDM Hub by mapping the INPUT_ROWID_OBJECT column in a landing table to the ROWID_OBJECT column in a staging table.
The load process compares the values from the ROWID_OBJECT column in a staging table with the ORIG_ROWID_OBJECT column values of the cross-reference table that is associated with a base object. If the values match, the load process updates the records in the cross-reference table.
The load process updates the existing cross-reference record with the incoming record if the values of the PKEY_SRC_OBJECT and ROWID_SYSTEM columns match. Otherwise, the load process inserts a new cross-reference record that has the values of the incoming record, and merges with the existing cross-reference record. The load process updates the base object record with the winning cell values from the cross-reference records.
When you load a HUB_STATE_IND value of -1 for a specified source and specified row ID, the HUB_STATE_IND value is set to -1 for all cross-reference records of the specified row ID, regardless of the source. The MDM Hub considers the base object record to be deleted since all cross-reference records have a HUB_STATE_IND value of -1.
The initial data load for a base object inserts all records into the target base object. Therefore, enable loading by row ID for incremental loads that occur after the initial data load.

0 COMMENTS

We’d like to hear from you!