To Filter Default Values From the SBR, Blocking Query, or Match Process

1. To use flat files to define values to filter, create a flat file for each field to be filtered.

2. In this file, list each value to exclude for each filter definition you will create and separate each value by a delimiter.

3. In the Projects window, expand the master index application and then expand Filter.

4. Open filter.xml.

5. For each field to be filtered, define the elements and attributes described in Filter Definition Elements.

6. Save and close the file.

Example 5 Filter Definitions

The filter.xml file provides a simple format for you to define filters for survivor calculation, blocking queries, and matching. The following sample defines a rule that filters out the listed values from the FirstName field in the SBR. It defines a second rule that filters out the values listed in FirstNameFilters.txt from the SSN field.

<exclusion-List module-name="ExclusionFilter" 
parser-class="com.sun.mdm.index.configurator.impl.ExclusionFilterConfig">
  <field sbr="true" matching="false" blocking="false">
    <name>Person.FirstName</name>
    <value
      <field-value>Baby</field-value>
      <field-value>Baby Boy</field-value>
      <field-value>Baby Girl</field-value>
    </value>
  </field>
  <field sbr="true" matching="true" blocking="true">
    <name>Person.SSN</name>
    <value>
      <file delimiter="|">
        <file-name>SSN.txt</file-name>
      </file>
    </value>
</exclusion-List>

The filter values file for the SSN field in the above example would look similar to the following:

000000000|111111111|222222222|333333333|444444444|555555555|666666666|777777777|
888888888|999999999