Enterprise Data Preparation Administrator Guide > Getting Started > Configure Enterprise Data Preparation for Rules
  

Configure Enterprise Data Preparation for Rules

Configure Enterprise Data Preparation to enable users to apply rules that cleanse, transform, or validate data during data preparation.
  1. 1. Use Informatica Developer (the Developer tool) to import the rule metadata into the Model repository used by the Interactive Data Preparation Service.
    2. For more information about importing rule metadata, see the "Importing Rules and Mappings" topic in the Informatica Data Quality Content Installation Guide.
  2. 2. Configure the Model Repository Service used by the Interactive Data Preparation Service for rules.
    1. a. Disable the Model Repository Service.
    2. b. Use the Administrator tool to set the following custom properties:
      3. Custom Property
      Value
      CUSTOM_PROPERTIES.fined-grained-parsing
      true
      CUSTOM_PROPERTIES.sync-search
      true
    3. c. Recycle the Model Repository Service.
    4. d. Re-index the Model Repository Service. Click Actions. Click Search Index. Click Re-index.
  3. 3. Verify that the Content Management Service associated with the Model Repository Service used by the Interactive Data Preparation Service is available.
  4. 4. Verify that the Reference Data Location property for the Content Management Service is set to the connection name for the reference data warehouse database.
    5. The reference data warehouse stores reference data values for the reference data objects used in rules. For example, if a rule validates U.S. zip codes, the zip code values used in the rule are stored in the reference data warehouse.

Tools to complete this step:

Rule Errors

Users who use rules when preparing data might encounter errors.
The following table describes the errors that might occur when using rules:
Error Code
Description
#RULENOTFND
The rule is no longer available in the Model repository.
#RULEPERMISSIONDENIED
You do not have permissions to access the rule.
#DQMRSERR1
The application is unable to access the Model Repository Service.
#DQMRSERR2
The Model Repository Service is not available.
#DQMRSERR3
The Model Repository Service returned an error.
#DQDISSERR1
The application is unable to access the Data Integration Service.
#DQDISERR2
The Data Integration Service is not available.
#DQDISERR3
The Data Integration Service returned an error while evaluating the rule.
#AUTHERR
The user does not have permissions to connect to the Data Integration Service and the Model Repository Service.
#DQERR100
An unknown error occurred.
#LICENSE_ERR
The Informatica license is not valid for use of rules.
If a user reports an error when using rules, review the rules log file to troubleshoot the issue. The log file is available in the following directory on the node on which the Interactive Data Preparation Service runs:
<Informatica installation directory>/logs/<node>/services/DataPreperationService/rule_discovery_and_execution.log