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. Use Informatica Developer (the Developer tool) to import the rule metadata into the Model repository used by the Interactive Data Preparation Service.
For more information about importing rule metadata, see the "Importing Rules and Mappings" topic in the Informatica Data Quality Content Installation Guide.
- 2. Configure the Model Repository Service used by the Interactive Data Preparation Service for rules.
- a. Disable the Model Repository Service.
- b. Use the Administrator tool to set the following custom properties:
Custom Property | Value |
|---|
CUSTOM_PROPERTIES.fined-grained-parsing | true |
CUSTOM_PROPERTIES.sync-search | true |
- c. Recycle the Model Repository Service.
- d. Re-index the Model Repository Service. Click Actions. Click Search Index. Click Re-index.
- 3. Verify that the Content Management Service associated with the Model Repository Service used by the Interactive Data Preparation Service is available.
- 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.
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:
- •Informatica Developer
- •Informatica Administrator