Defining a Consolidation Object for Matching
Prerequisites: You have defined a consolidation object for cleansing project.
Use the same consolidation object that you created for your cleansing project and perform the steps given here.
Note:
Onedata lets you to skip the cleansing project when you are sure that the data is well cleansed and ready for matching. In which case, you can create a data object with columns to load the data and set the column with additional qualifier Cleansing Status Indicator. The value for this column must be 7 for OneData to select the column for matching.
To define a Consolidation object for a matching project
1. Open the data object which you have defined as the Consolidation object for your cleansing project.
2. In the Consolidation table, add a numeric column.
3. Do one of the following:
For a single Gold model table, set the base object as the Gold object and the base column as the primary key of the Gold object.
For a multiple Gold model table, use the view created as the base object and set the DETAIL primary key as the base column.
During the data quality process, this column represents the primary key of the record in the Gold object to which the Consolidation record is linked.
