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

Enabling and Disabling Fuzzy Query


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, the Siebel application uses fuzzy query mode automatically, regardless of which data quality product 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 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. If wildcards (*) or quotation marks (") are used in a fuzzy query, then that fuzzy query will not be effective. Also, if mandatory fuzzy query fields are missing, then fuzzy query is disabled for that particular query.

Enabling Fuzzy Query

Use the following procedure to enable fuzzy query.

To enable fuzzy query

  1. Navigate to the Administration - Data Quality screen, then the 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.

Disabling Fuzzy Query

Use the following procedure to disable fuzzy query.

To disable fuzzy query

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

Using Fuzzy Query

Example of Enabling and Using Fuzzy Query with Accounts

Siebel Data Quality Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.