Defining Project-Object Mapping Based on a Cleansing Project
Use the following procedure to associate the attributes from a cleansing project with the columns of Consolidation objects and Consolidation Gold objects in OneData.
1. On the Menu toolbar, click Define > Data Quality > Consolidation > Project Mapping.
2. In Filter by Project, select the data quality cleansing project with which you want to work.
3. On the Command toolbar, click Project-Object Mapping.
4. On the Command toolbar, click Add New Mapping.
5. Define the following mapping:
a. In Staging Object, select the Consolidation or Consolidation Gold object.
b. Map the object attributes as shown in this sample
Staging Object Attribute | Project Attribute |
BUSINESSNAME | IN_Organization |
ADDRESSLINE | IN_Address |
POSTALCODE | IN_PostalCode |
COUNTRY | IN_Country |
C_BUSINESSNAME | OUT_Organization |
C_ADDRESSLINE | OUT_Address |
C_STATE | OUT_Administrative_Area |
C_POSTALCODE | OUT_PostalCode |
C_COUNTRY | OUT_Country |
WINDOWKEY | Windowkey1 |
c. For a Locate project, in Staging Field Status Attribute, select the field status (FS) attribute for the project.
This field enables the attribute OUTPUT to provide information on how the attribute was cleansed. For example, the attribute output could be fsIdentifiedNoChange, fsVerifiedSmallChange, fsIdentifiedContext, and so on.
d. Click Save Mapping after defining each attribute.
e. Repeat all the steps for defining attributes until you have defined all required attributes.