OneData 10.7 | Managing Master Data with webMethods OneData | webMethods OneData Consolidation MDM Guide | Configuring Data Quality Models | Creating a Data Object for Consolidation (Staging)
 
Creating a Data Object for Consolidation (Staging)
To create a consolidation data object, you must add the additional qualifier, Consolidation Object. The Consolidation Object contains data loaded from the source system and columns that persist the cleansed data.
Note:
Software AG recommends prefixing the cleansed column names with C_ or CLN_ to differentiate them from data originating from source systems.
1. On the Menu toolbar, click Define > Objects and navigate to the required folder.
2. Click Add Object.
3. Complete the following fields and click Save:
Field
Value
Name
CDI_StagingObject
Display Name
CDI_StagingObject
Object Type
Data Object
Additional Qualifier
Consolidation Object
Physical Table
CDI_StagingTable
4. On the Structure tab, click Add Column.
a. Create the following columns, specifying ID as the primary key.
Column Name
Description
ID
Set as the primary key.
BUSINESSNAME
The name of the business.
ADDRESSLINE
The address of the business.
POSTALCODE
The postal code of the business.
COUNTRY
The country of the business address.
C_BUSINESSNAME
The cleansed column for the business name.
C_ADDRESSLINE
The cleansed value of the business address.
C_STATE
The cleansed value of the business state.
C_POSTALCODE
The cleansed value of the business postal code.
C_COUNTRY
The cleansed value of the business country.
WINDOWKEY
CLEANSINGSTATUS
In Column Qualifier set the value as Cleansing Status Indicator.
GOLDLINK
In Base Object, set the value as CDI_GoldObject. In Base Column, set the value as ID to indicate that the column is the primary key of the Gold object.
b. Click Save.
5. Click Create Table.
6. Create a primary key for the object.
7. Specify a primary key constraint name and select the column ID as the primary key.
8. Click Save.