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 from the Data Quality cleansing process.
Note: Software AG recommends prefixing the cleansed column names with C_ or CLM_ 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. |
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.