User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Component Rules in ONE Desktop

Component rules can be used for complex data validation tasks, namely in cases when the rule logic supported in Ataccama ONE is not sufficient. See also Validation Components and Data Quality.

Component rules must fulfill the following conditions in order to ensure the correct results are returned:

  1. The total number of input records must match the total number of output records in the component.

  2. The order of output records must match the order of input records.

Prerequisites

Create a component rule

To create a component rule in ONE Desktop:

  1. Open ONE Desktop.

  2. Connect to Ataccama ONE Platform Server.

  3. Navigate to ONE Metadata Explorer tab.

  4. Select the component you have created in ONE (in the current example, the rule is Email Check).

    Select component in Metadata Explorer
  5. Right-click the component and select Edit Component.

  6. In the Component Editor, implement the validation logic for your component.

    Edit component
  7. Save your changes.

Score the records

The score is used as a numeric expression of the severity level for each invalid record. This is mainly useful for monitoring projects as it helps detect the records with issues more easily and in turn improve the data quality faster.

Typically, the higher the score, the more critical the issue is, although the specific values are arbitrary. For example, if the record is missing a non-critical value, the score could be 100, and if a critical value is missing, the record score could be 10000.

To be able to score invalid records by severity:

  1. Add the Score Column Assigner step to the plan. This adds an output column to data where you can see the score for each record.

    Add Column Assigner
  2. Double-click the Score assigner to open it.

  3. Provide the logic for assigning the score. For example, if the record is invalid, the score could be 1000.

    Record scoring
  4. Select OK and save your changes.

Publish the component

  1. Right-click the component and select Push Changes to send the changes to ONE.

    Push changes
  2. Select OK to confirm.

    • To make the component available for use, change the status of the component to Implemented. Right-click the component and select Mark As > Implemented.

      Mark component as implemented

Was this page useful?