Creating a Rule-based Data Domain

1. Click New > Data Domain.
The New Data Domain wizard appears.
2. In the Name field, enter a name for the data domain.
Note: Do not include whitespace, numbers, or special characters except the at (@), hash ( #), or underscore (_) in the data domain name.
3. In the Description field, enter a brief description of the data domain.
4. Select one of the following options for the Specify Rules for this data domain field:
• - Yes. Specify data rules, column name rules, or both the rules for the data domain.
• - No. If you do not specify rules in the data domain, then it is a smart data domain. Smart data domains are user-defined data domains that can be manually curated and propagated to similar columns.
5. To choose a data rule for the data domain, click Browse.
6. In the Data Rule dialog box, choose one of the following rules:
• - Select Reference Table. Select the option, and choose a reference table in the list of records. When you choose a reference table, the column data in the reference table is used to associate data domains to assets.
• - Specify Regular Expression. Select the option, and enter a regular expression to match string data. A regular expression is a specialized formula for matching text strings that follow a pattern. The syntax used for regular expression must conform to the grammar rules and tokens described here: https://docs.informatica.com/data-catalog/shared-content-for-data-catalog/10-5/transformation-language-reference/functions/reg_extract.html.
• - Select Rule. Select the option, and choose a rule in the list of records. You can choose mapplet-based rules that were created using Informatica Analyst or Informatica Developer client. For more information about using mapplet based rules, see: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-5/developer-mapping-guide/mapplets/mapplet-validation/mapplet-as-a-rule-validation.html.
7. Click Select.
The data rule appears in the Data Rule field.
8. To choose a column name rule for the data domain, click Browse.
9. In the Column Name Rule dialog box, choose one of the following rules:
• - Select Reference Table. Select the option, and choose a reference table in the list of records. When you choose a reference table, the column data in the reference table is used to associate data domains to assets.
• - Specify Regular Expression. Select the option, and enter a regular expression to match string data. A regular expression is a specialized formula for matching text strings that follow a pattern. The syntax used for regular expression must conform to the grammar rules and tokens described here: https://docs.informatica.com/data-catalog/shared-content-for-data-catalog/10-5/transformation-language-reference/functions/reg_extract.html.
• - Select Rule. Select the option, and choose a rule in the list of records. You can choose mapplet-based rules that were created using Informatica Analyst or Informatica Developer client. For more information about using mapplet based rules, see: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-5/developer-mapping-guide/mapplets/mapplet-validation/mapplet-as-a-rule-validation.html.
10. Click Select.
The column rule appears in the Column Rule field.
11. In the Conflict Resolution field, choose one of the following options:
• - If rules conflict, data overrides column name rule. Uses data rule result to auto-accept data domains.
• - If rules conflict, column name overrides data rule. Uses column name rule result to auto-accept data domains.
• - Match data and column name rule. Data domains are auto-accepted when the data and column name rule results match.
• - Match data or column name rule. Data domains are auto-accepted when data or column name rule results match.
If you do not select any option from the Conflict Resolution field, Enterprise Data Catalog auto-accepts data domains based on the data rule results.
12. Configure the following data conformance properties if you specify rules for the data domain:
• - Minimum conformance. Enter a minimum conformance percentage for the data domain.
• - Auto accept if more than. Enter a percentage. Enterprise Data Catalog accepts the data domain automatically if the data domain match exceeds the configured percentage.
• - Row Count. Enter the number of minimum rows for data conformance.
13. To add the data domain to multiple data domain groups, perform the following steps:
a. Click in the Data Domain Groups pane.
The Data Domain Groups dialog box appears.
1. b. Select the data domain groups, and click Select.
The list of data domain groups appears in Data Domain Groups pane.
c. After you choose the data domain groups for the data domain, you can also remove a data domain group. Click to remove a data domain group.
14. If you specify rules for the data domain, you can also add multiple proximity data domains for the data domain.
Perform the following steps to add a proximity data domain:
a. In the Proximity Data Domains section, click .
The Data Domains dialog box appears.
1. b. In the Data Domains dialog box, choose a data domain, and click Select.
c. In the Proximity Data Domains section, click to add another proximity data domain.
d. In the Proximity Data Domains section, click to remove a proximity data domain.
15. Click Save to save the data domain.