1. Data Management
  2. Data Quality Studio
  3. General setup

Set up configurable lookup

You can set up a configurable lookup to define the possible options in a field.

You can define the possible options for a configurable lookup in these ways:

  • User defined list: Set up the desired options manually.
  • Dynamic query: Apply a dynamic query to define the desired options.
  • Web service: Use a web service to get the desired options.

To apply a configurable lookup, set up a validation rule of type Configurable lookup. You can use a configurable lookup on several validation rules.

This topic explains how to set up a configurable lookup.


Data quality administrator Data quality administrator The data quality administrator (DQSDataQualityAdministrator) can set up and maintain: Data quality policies Data quality studio parameters Data quality studio general setup Start Start What is the desired  configurable lookup type? What is the desired  configurable lookup type? Set up configurable lookup - User defined list Set up configurable lookup - User defined list You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field. Procedure 1. Go to Data quality studio > Setup > Configurable lookups. 2. Click New. 3. In the Configurable lookup ID field, type a value. 4. In the Description field, type a value. 5. In the Configurable lookup type field, select 'User defined list'. 6. Click Save. 7. Expand the User defined list configurable lookup values section. 8. Click New. 9. In the Value field, type a value. 10. In the Description field, type a value. 11. Sub-task: Change sequence of configurable lookup values. 12. In the User defined list of configurable lookup values section, in the list, find and select the desired record. 13. Click Up. 14. In the User defined list of configurable lookup values section, in the list, find and select the desired record. 15. Click Down. 16. Close the page. Dynamic query exists? Dynamic query exists? Set up dynamic query

Set up dynamic queries

Use a dynamic query to find one or more records in the database. The found records are the input for further processing.

You can use a dynamic query on:

  • An enrichment rule of type Data query.
  • An action rule of type Data query.
  • A condition that is applied to a validation rule, duplicate check rule, or action rule.
  • A configurable lookup of type Dynamic query. You can apply the configurable lookup on a validation rule of type Configurable lookup.

To define a query range, you can use a function.

 Set up configurable lookup - Dynamic query Set up configurable lookup - Dynamic query You can use a dynamic query to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Dynamic query'. Procedure 1. Go to Data quality studio > Setup > Configurable lookup. 2. Click New. 3. In the Configurable lookup ID field, type a value. 4. In the Description field, type a value. 5. In the Configurable lookup type field, select 'Dynamic query'. 6. Click Save. 7. In the Dynamic query field, enter or select a value. 8. Sub-task: Define the field settings for the configurable lookup. 9. Expand the Dynamic query configurable lookup values section. 10. Define the dynamic query fields to be shown on the configurable lookup. You can define several fields. Only the value from one field can be input for the field using the configurable lookup. All other fields are informational. Click New. Note: For example, you use a configurable lookup of type Dynamic query to select a city. To help select the correct city, you can show the related country and state in the configurable lookup. Add these fields to the configurable lookup: country, state, and city. Specify city as the value field. 11. In the Field name field, enter or select a value. 12. Specify which field defines the value selected from the configurable lookup. Only the value from this field is input for the field using the configurable lookup. Select the Value field check box. Note: The field can be another field than the field to which you apply a validation rule that uses the configurable lookup. Make sure the data type of the field is compatible with the data type of the field to which you apply a validation rule that uses the configurable lookup. 13. Sub-task: Add query ranges. 14. Expand the Add query ranges section. 15. Click New. 16. In the Range field, enter or select a value. Note: You set the range values on the validation rule. 17. Close the page. Notes The Data Quality Studio 10.0.42.13 release changes the Dynamic query configurable lookup values section. Redesign the section setup for configurable lookups of type Dynamic query created before this release. If you do not redesign the section setup, these configurable lookups stop working. Web service exists? Web service exists? Set up web service configuration

Set up web service configuration

You can set up data quality policy rules that use a web service.

You can use a web service:

  • Validation rule to validate if a field value matches a value in another internal or external source, using a web service.
  • Enrichment rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule.
  • Action rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule.
Before you can set up a web service rule, set up the web service configuration to be used.

 Set up configurable lookup - Web service Set up configurable lookup - Web service You can use a web service to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Web service'. Procedure 1. Go to Data quality studio > Setup > Configurable lookups. 2. Click New. 3. In the Configurable lookup ID field, type a value. 4. In the Description field, type a value. 5. In the Configurable lookup type field, select 'Web service'. 6. Click Save. 7. Expand the Web services section. 8. In the Web service field, enter or select a value. 9. In the WebService lookup value field field, enter or select a value. 10. In the WebService lookup value description field field, enter or select a value. 11. In the Minimum input length field, enter a number. 12. Close the page. End End User defined list Dynamc query Web service No Yes No Yes

Activities

Name Responsible Description

Set up configurable lookup - User defined list

Data quality administrator

You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field.

Set up dynamic query

Data quality administrator

Use a dynamic query to find one or more records in the database. The found records are the input for further processing.

You can use a dynamic query on:

  • An enrichment rule of type Data query.
  • An action rule of type Data query.
  • A condition that is applied to a validation rule, duplicate check rule, or action rule.
  • A configurable lookup of type Dynamic query. You can apply the configurable lookup on a validation rule of type Configurable lookup.

To define a query range, you can use a function.

Set up configurable lookup - Dynamic query

Data quality administrator

You can use a dynamic query to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Dynamic query'.

Set up web service configuration

Data quality administrator

You can set up data quality policy rules that use a web service.

You can use a web service:

  • Validation rule to validate if a field value matches a value in another internal or external source, using a web service.
  • Enrichment rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule.
  • Action rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule.
Before you can set up a web service rule, set up the web service configuration to be used.

Set up configurable lookup - Web service

Data quality administrator

You can use a web service to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Web service'.

Provide feedback