Siebel Data Quality Administration Guide > Using Siebel Data Quality >

Using Fuzzy Query

To run a query using fuzzy query, this facility must be enabled and several conditions must be met as described in Enabling and Disabling Fuzzy Query.

In particular:

• 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.

If the conditions for fuzzy query are not satisfied, then any queries you make use standard query functionality.

Using Fuzzy Query for Accounts

Use the following procedure to use fuzzy query for accounts.

To use fuzzy query for accounts

1. Navigate to the Accounts screen, then the Accounts List view.
2. Click the Query button.
3. Enter your query, and then click Go.

   The query results contain fuzzy matches in addition to regular query matches.

Using Fuzzy Query for Contacts

Use the following procedure to use fuzzy query for contacts.

To use fuzzy query for contacts

1. Navigate to the Contacts screen, then the Contacts List view.
2. Click the Query button.
3. Enter your query, and then click Go.

   The query results contain fuzzy matches in addition to regular query matches.

Using Fuzzy Query for Prospects

Use the following procedure to use fuzzy query for prospects.

To use fuzzy query for prospects

1. Navigate to the List Management screen, then the Prospects view.
2. Click the Query button.
3. Enter your query, and then click Go.

   The query results contain fuzzy matches in addition to regular query matches.

Example of Enabling and Using Fuzzy Query with Accounts

This topic gives an example of enabling and using fuzzy query. You might use this feature differently, depending on your business model.

In the following example, you enable fuzzy query for accounts, and then enter the query criteria. The query results contain fuzzy matches from the DeDuplication business service in addition to regular query matches.

NOTE:  EAI Siebel Adapter does not support fuzzy queries. In addition, scripting does not support fuzzy queries.

To enable and use fuzzy query for accounts

1. Perform the steps in Enabling and Disabling Fuzzy Query
2. Perform the steps in Enabling Siebel Data Quality at the User Level.

   NOTE:  For this example, set the Fuzzy Query - Max Returned data quality setting to 10.

3. Navigate to the Accounts screen, then the Account list view.
4. Enter your query, and then click Go.

   For this example, in the Name field, enter Symphony.

   Up to 10 records having Name set to Symphony are displayed.

   NOTE:  If the number of Symphony account records is fewer than 10, then the fuzzy query results includes records where symphony is lowercase (as well as uppercase). For example, if four records for Symphony and 100 records for symphony are found in the database, the fuzzy query result shows four Symphony records and six symphony records. However, if fuzzy query is disabled, only the four Symphony records appear.