Defining a Master Index Field to be Normalized (Repository)

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 national domains 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 master index application you want to modify, and then click Open.

2. If the Configuration Editor dialog box appears, click Edit to check out the listed files.

   The Configuration Editor appears.

3. 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 (Repository).

4. Click the Normalization tab.

   The Normalization page appears.

5. Click Add.

   The Normalized Field dialog box appears.

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

7. To specify a national domain for the type of data being standardized, do the following:

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

   2. In the Locale Codes section, click Add.

   3. On the dialog box that appears, enter values in the fields described in Master Index Locale Codes Properties (Repository).

   4. Click OK.

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

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

   The new normalization definition appears in the list.

9. On the Configuration Editor toolbar, click Save.

To Define a Field to be Normalized (XML Editor)

Before You Begin

In the Object Definition file, create the field that will contain the new normalized value. For more information, see Adding a Field to the Master Index Object Structure (Repository).

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

   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 (Repository).

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 (Repository) and Master Index Locale Codes Properties (Repository)).

   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 Locale Codes Properties (Repository)).

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 (Repository)).

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 (Repository)).

7. Save and close the file.

Example 2 First and Last Name Normalization

<structures-to-normalize>
         <group standardization-type="PersonName" domain-selector=
          "com.stc.eindex.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>