Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Creating rule occurrences

Creating rule occurrences

Create rule occurrences on the
Metrics
tab. The tab appears after you select
Scorecard Metrics
from the
Menu
option. After you create rule occurrences, you must save and run the profile. You can use only rule specifications to create a rule occurrence and other
Data Quality
assets or mapplets cannot be used.
You can create rule occurrences on a profile with rules that have single or multiple output fields. To create a rule occurrence with multiple output fields, select an output field that is marked as available.
Data Profiling
marks the output field name as available to indicate that the scorecard uses it. The output field name is marked available and ranked in precedence in the following order: isValid, isTrue, out_valid, out_status, PrimaryRuleSet.
Data Profiling
does not list rules with multiple output fields on the
Metrics
tab, if the field names are not isValid, isTrue, out_valid, out_status, or PrimaryRuleSet.
Perform the following steps to create a rule occurrence:
  1. On the
    Metrics
    tab, click Add ( The image shows the Add icon. 
				).
  2. In the
    Create Rule Occurrence
    dialog box, choose a rule specification output to measure. You can either select a single output field or multiple output field.
  3. Click
    Next
    .
  4. In the
    Create Rule Occurrence
    dialog box, perform the following steps:
    1. Specify a name and description for the rule occurrence in the
      General Details
      section.
    2. Define valid threshold values for scorecard generation in the
      Rule Occurrence Thresholds
      section. You can modify a threshold after you create a rule occurrence without running the profile again.
  5. Click
    OK
    .
    The rule appears on the
    Rule Occurrences
    tab.
  6. Continue to add more rule occurrences to the
    Rule Occurrences
    tab as necessary.
  7. Choose one of the following options to save and run the profile:
    • Click
      Save
      to save the profile.
    • Click
      Run
      to save and run the profile.
    You can view the scorecard results only when you run the profile again after you create or update rule occurrences.
    When you delete a rule that is associated with a data profiling task, the corresponding rule occurrences are automatically deleted from the profile.

0 COMMENTS

We’d like to hear from you!