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.