Defining a Master Index Field to be Normalized

When you define a field for normalization, you define which field contains the data that needs to be normalized and which field will contain the normalized data. You can also specify one or more variants to use for normalization. A sample normalization structure for the XML file appears at the end of these instructions.

To Define a Field to be Normalized (Configuration Editor)

1. In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.

   The Configuration Editor appears.

2. In the object structure in the left pane, add the field that will contain the normalized value.

   For more information, see Adding a Field to the Master Index Object Structure.

3. Click the Normalization tab.

   The Normalization page appears.

4. Click Add.

   The Normalized Field dialog box appears.

5. Enter or select a value for each of the fields described in Master Index Normalization and Standardization Structure Properties.

6. To specify a variant for the type of data being standardized, do the following:

   1. In the Variant Field Name field, select the field whose value in incoming records will indicate which variant to use.

   2. In the Variants section, click Add.

   3. On the dialog box that appears, enter values in the fields described in Master Index Variants Properties.

   4. Click OK.

      If you selected the multiple domain selector, you can add multiple variants; otherwise, you can add one default variant and one field-defined variant.

7. On the Normalized Field dialog box, click OK.

   The new normalization definition appears in the list.

8. On the Configuration Editor toolbar, click Save.

To Define a Field to be Normalized (XML Editor)

Before You Begin

In object.xml, create the field that will contain the new normalized value. For more information, see Adding a Field to the Master Index Object Structure.

1. In the Projects window, expand the Configuration node in the project you want to modify, and then double-click mefa.xml.

   The file opens in the NetBeans XML editor.

2. In the structures-to-normalize element, create and name a new group element.

   Make sure the new element falls within the structures-to-normalize element, but outside any existing group tags.

3. In the new group element, define the standardization-type and domain-selector attributes (these are described in Master Index Normalization and Standardization Structure Properties.

4. If you specified the multiple domain selector for the domain-selector attribute, do the following:

   1. In the group element, create a locale-field-name element and a locale-maps element (described in Master Index Normalization and Standardization Structure Properties and Master Index Variants Properties).

   2. For each variant you want to use, define a locale-codes, value, and locale element in the locale-maps element (described in Master Index Variants Properties).

5. To specify the source fields to normalize, do the following:

   1. Create a new unnormalized-source-fields element in the group element.

   2. Create a source-mapping element in the new unnormalized-source-fields element.

   3. Define the unnormalized-source-field-name and standardized-object-field-id elements (these are described inMaster Index Normalization and Standardization Structure Properties).

6. To map the normalized data to destination fields, do the following:

   1. Create a new normalization-targets element under the unnormalized-source-fields element that defines the field to map.

   2. Create a target-mapping element in the new normalization-targets element.

   3. Define the standardized-object-field-id and standardized-target-field-name elements (these are described in Master Index Normalization and Standardization Structure Properties).

7. Save and close the file.

Example 2 First and Last Name Normalization

<structures-to-normalize>
         <group standardization-type="PersonName" domain-selector=
          "com.sun.mdm.index.matching.impl.MultiDomainSelector">
            <locale-field-name>Person.PobCountry</locale-field-name>
            <locale-maps>
              <locale-codes>
                <value>GB</value>
                <locale>UK</locale>
              </locale-codes>
              <locale-codes>
                <value>UNST</value>
                <locale>US</locale>
              </locale-codes>
              <locale-codes>
                <value>Default</value>
                <locale>US</locale>
              </locale-codes>
            </locale-maps>
            <unnormalized-source-fields>
               <source-mapping>
                  <unnormalized-source-field-name>
                   Person.Alias[*].FirstName
                  </unnormalized-source-field-name>
                  <standardized-object-field-id>FirstName
                  </standardized-object-field-id>
               </source-mapping>
               <source-mapping>
                  <unnormalized-source-field-name>
                   Person.Alias[*].LastName
                  </unnormalized-source-field-name>
                  <standardized-object-field-id>LastName
                  </standardized-object-field-id>
               </source-mapping>
            </unnormalized-source-fields>
            <normalization-targets>
               <target-mapping>
                  <standardized-object-field-id>FirstName
                  </standardized-object-field-id>
                  <standardized-target-field-name>
                     Person.Alias[*].StdFirstName
                  </standardized-target-field-name>
               </target-mapping>
               <target-mapping>
                  <standardized-object-field-id>LastName
                  </standardized-object-field-id>
                  <standardized-target-field-name>
                     Person.Alias[*].StdLastName
                  </standardized-target-field-name>
               </target-mapping>
            </normalization-targets>
         </group>