Stage Process

The stage process reads data from a landing table, cleanses the data, and moves the cleansed data into a staging table in the Hub Store. The
MDM Hub
uses the staging table as a temporary, intermediate storage in the flow of data from landing tables into base objects.
Mappings help the transfer and cleansing of data between landing and staging tables during the stage process. A mapping defines which landing table column the
MDM Hub
must use to populate a column in the staging table. A mapping defines the standardization and verification that the
MDM Hub
must perform before it populates a staging table.
The
MDM Hub
standardizes and verifies data by using the cleanse functions that you configure. Use cleanse functions for specialized cleansing functionality, such as address verification, address decomposition, gender determination, text casing, and white space compression. The output of the cleanse function becomes the input to the target column in the staging table.
You can perform the stage process in Informatica platform, where the data directly moves from the source to the
MDM Hub
staging tables. The Informatica platform staging process is not a batch process.

0 COMMENTS

We’d like to hear from you!