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

MDM Hub Staging Overview

MDM Hub Staging Overview

MDM Hub
staging moves source data from landing tables to the staging tables associated with a base object. To perform
MDM Hub
staging, you must create landing tables and staging tables. Before you perform
MDM Hub
staging, you must load data into the landing tables.
The MDM Hub can move data from a single landing table to multiple staging tables. However, each staging table receives data from only one landing table.
Before you run a stage job, define mappings between the landing and staging tables. Mappings link a source column in the landing table with a target column in the staging table. When you run the stage job, the
MDM Hub
moves data based on the mappings from the landing table columns to the staging table columns.
During the stage process, the
MDM Hub
processes one block of 250 records at a time. If there is a problem with a record in the block, the
MDM Hub
moves the record to the reject table. A record could be rejected because the value of a cell is too long, or because the record’s update date is later than the current date. After the
MDM Hub
moves the rejected record, the
MDM Hub
stops processing the remaining records in the block, and moves on to other blocks. When the stage process completes, run the job again. The records that were not processed are picked up again and processed.
If you want to perform cleanse operations during the stage process, use the
MDM Hub
cleanse functions. Configure data cleansing in the mapping. When you perform
MDM Hub
staging, you can set up delta detection and audit trails. The stage process prepares data for the load process.

0 COMMENTS

We’d like to hear from you!