Siebel Data Quality Administration Guide > Enabling and Disabling Data Matching and Data Cleansing >

Enabling and Disabling Fuzzy Query


Siebel Data Quality provides an advanced query feature, known as fuzzy query, that makes searching more intuitive and effective. For general information about fuzzy query functionality, see Fuzzy Query.

When all of the following conditions are satisfied, your Siebel application uses fuzzy query mode automatically, regardless of which SDQ product module you are using. However, if any of the conditions are not satisfied, the Siebel application uses the standard query mode:

  • Data matching must be enabled in the Administration - Data Quality Settings view; see Specifying Data Quality Settings.
  • Data matching must not be disabled for the current user in the User Preferences - Data Quality view; see Enabling Siebel Data Quality at the User Level.
  • Fuzzy query must be enabled in the Administration - Data Quality Settings view; Fuzzy Query Enabled must be set to Yes.
  • Fuzzy query must be enabled for the current user in the User Preferences - Data Quality view; Fuzzy Query Enabled must be set to Yes.
  • The query must not use wildcards.
  • The query must specify values in fields designated as fuzzy query mandatory fields. For information about identifying the mandatory fields, see Identifying Mandatory Fields for Fuzzy Query.
  • The query must leave optional fields blank.

The following procedures describe how to enable and disable fuzzy query in the Data Quality Settings.

To enable fuzzy query

  1. Navigate to the Administration - Data Quality screen > Data Quality Settings view.
  2. Click New to create a new record:
    1. In the Name field, choose Fuzzy Query Enabled.
    2. In the Value field, choose Yes.
  3. (Optional) If you want to set a maximum number of returned records, click New to create a new record:
    1. In the Name field, choose Fuzzy Query - Max Returned.
    2. In the Value field, enter a number from 10 to 500.

To disable fuzzy query

  1. Navigate to the Administration - Data Quality screen > Data Quality Settings view.
  2. In the Data Quality Settings list, select Fuzzy Query Enabled, and in the Value field, choose No.

For more information about fuzzy query, see Using Fuzzy Query, and Example of Enabling and Using Fuzzy Query with Accounts.

Siebel Data Quality Administration Guide Copyright © 2006, Oracle. All rights reserved.