Defining Additional Mappings 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 Attribute, provide a suitable name for the attribute.
b. In Attribute Type, select Inbound or Outbound.
c. To ensure a validation error is displayed when the attribute is not mapped in the project object mapping, select Is Required .
5. Click Save Mapping and, if you require more attributes, repeat the steps until you have defined all attributes, including the windowkey attributes.
6. Define Windowkey expressions in the OD_MD_DQSRV_MPNGPROP table, setting prop_id to 36002.
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.