Mapping a Matching Project to Consolidation (Staging) and Consolidation Gold Objects
Use the following procedure to create a Project-Object Mapping from a matching project to the Consolidation (Staging) object and the Consolidation Gold object.
1. On the Menu toolbar, click Define > Data Quality > Consolidation > Project Mapping.
2. In Filter by Project, select the appropriate matching project for the data quality server used.
3. Click Project-Object Mapping.
4. Click Add New Mapping.
5. Define the following fields and click Save.
a. In Staging Object, select the Consolidation object.
b. In Staging Object Attribute, select the appropriate attribute for which the mapping is required.
c. In Project, select the appropriate matching project.
d. In Project Attribute, select the appropriate project attribute.
e. In Gold Object, select the appropriate Consolidation Gold object.
f. In Gold Object Attribute, select the appropriate Gold attribute to match against the staging attribute.
Note:
Select the Outbound Attribute type to display the Gold objects and associated attributes.
Sample listing of attributes are shown below:
Staging Object Attribute | Project Attribute | Gold Object Attribute |
C_BUSINESSNAME | BusinessName | BusinessName |
C_ADDRESSLINE | StreetAddress | StreetAddress |
C_STATE | State | State |
C_POSTALCODE | PostalCode | PostalCode |
C_COUNTRY | Country | Country |
WINDOWKEY | WindowKey | WindowKey |
g. Select Is Window Key? if you are mapping a Windowkey.
If the mapping is for a OneData matching project, and the selected attribute was defined using the Add Windowkey option, this check box is automatically selected and cannot be modified. However, you can use Is Window Key? to assign all other attributes as Windowkeys.