Predefined Rules
Predefined rules are rules created in the Developer tool or provided with the Developer tool and Analyst tool. Apply predefined rules to the column profiles to modify or validate source data.
Predefined rules use transformations to define rule logic. You can use predefined rules with multiple profiles. In the Model repository, a predefined rule is a mapplet with an input group, an output group, and transformations that define the rule logic.
Predefined Rules Process
Use the New Rule Wizard to apply a predefined rule to a profile.
You can perform the following steps to apply a predefined rule:
- 1. Open a profile.
- 2. Select a predefined rule.
- 3. Review the rules parameters.
- 4. Select the input column. You can select multiple columns if you want to apply the rule to more than one column.
- 5. Configure the profiling options.
Applying a Predefined Rule
When you apply a predefined rule, you select the rule and configure the input columns and output columns for the rule. Apply a predefined rule to use a rule promoted as a reusable rule or use a rule created by a developer.
1. In the Library workspace, select the project that contains the profile, or select the profile in the Assets pane.
2. Click Actions > Open to open the profile.
The summary view appears in the Discovery workspace.
3. Click Actions > Edit Profile.
The Profile Wizard appears.
4. Click Specify Rules and Filters.
5. In the Specify Rules and Filters screen, click Actions > Apply an Existing Rule in the Rules panel.
The Apply Rule Wizard dialog box appears.
6. Select a rule, and click Next.
7. Click Add.
The Choose columns for input port dialog appears.
8. Select a field and an input column. Click OK.
The input columns and output columns appear in the Apply Rule Wizard dialog box.
9. In the Apply Rule Wizard dialog box, click OK.
The rule appears in the Specify Rules and Filters screen.