Defining Project-Object Mapping for a Locate Cleansing Project
When you define a Locate cleansing project, OneData automatically adds pre-defined attributes that are commonly required to perform cleansing. If you need more attributes, you can add them to the project using the Add New Mapping menu on the Command toolbar. In addition to following the steps in the OneData user interface, add metadata to the database using the insert statements described at the end of this procedure.
1. On the Menu toolbar, click Define > Data Quality > Consolidation > Project Mapping.
2. In Filter by Project, select the Locate cleansing project.
3. On the Command toolbar, click Add New Mapping.
4. Define the attribute properties as follows:
a. In Project, select the Locate project.
b. In Attribute, specify the attribute name.
c. In Attribute Type, select attribute type — inbound or outbound.
Note: If the attribute is meant to be a Windowkey, set it as an outbound attribute.
d. Click Save Mapping and, if you require more attributes, repeat the steps until you have defined all attributes, including the windowkey attributes.
5. Define Windowkey expressions in the OD_MD_DQSRV_MPNGPROP table, setting prop_id to 36002.
For more details on Windowkey attributes for
Locate Cleansing projects, see
Windowkeys.
Use the following code sample as a guide. Use all of the insert states to create a Windowkey.
INSERT INTO OD_MD_DQSRV_MPNG (DQ_SRV_TYP, DQ_SRV_MPNG_ NM)
VALUES (1000, 'Windowkey08 ');
INSERT INTO OD_MD_DQSRV_MPNGPROP (DQ_SRV_MPNG_ID, PROP_ID, PROP_ VAL)
VALUES ((SELECT DQ_SRV_MPNG_ID FROM OD_MD_DQSRV_M PNG
WHERE DQ_SRV_TYP=1000 AND DQ_SRV_MPNG_NM = 'Windowkey07'), 36000, 'Windowkey08 ');
INSERT INTO OD_MD_DQSRV_MPNGPROP (DQ_SRV_MPNG_ID, PROP_ID, PROP_VAL)
VALUES ((SELECT DQ_SRV_MPNG_ID FROM OD_MD_DQSRV_M PNG
WHERE DQ_SRV_TYP=1000 AND DQ_SRV_MPNG_NM = 'Windowkey08'), 36001, '2 ');
INSERT INTO OD_MD_DQSRV_MPNGPROP (DQ_SRV_MPNG_ID, PROP_ID, PROP_VAL)
VALUES ((SELECT DQ_SRV_MPNG_ID FROM OD_MD_DQSRV_M PNG
WHERE DQ_SRV_TYP=1000 AND DQ_SRV_MPNG_NM = 'Windowkey08'), 360 02,
'PostalCodeCHAR(59)CHAR(59)^.{0,3}||Address1CHAR(59)CHAR(59)^.{0, 1}|
[bcdfghjklmnpqrstvwxyzBCDFGHJKLMNPQRSTVWXYZ]+');
Note: To add attributes that are not Windowkeys, use only the first two insert statements in this sample to create the new attributes.