About Out-of-the-Box Attribute Business Rules - trillium_discovery - trillium_quality

About Out-of-the-Box Attribute Business Rules - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Quality

Trillium > Trillium Discovery

Version

17.1

Language

English

Product name

Trillium Quality and Discovery

Title

Trillium Control Center

Topic type

How Do I

Overview

Configuration

Reference

Administration

Installation

First publish date

2008

The following table lists ten ABRs that can be added to each attribute when an entity is created and describes how each rule (when enabled) runs a compliance check against attributes when data is first loaded or when a rule is re-analyzed.

Note: These rules are contained in the Standard library attribute. Your TSS administrator must set the Copy standard attribute business rules to attributes option in the Repository Manager before the rules can be automatically copied to attributes.If this setting is not enabled, you can still copy them to attributes and run analysis on an as-needed basis.

ABR Name	Description
Null Check	Checks the attribute for null values against a specified threshold
Patterns Check	Checks the attribute for valid and invalid patterns against a specified threshold
Predominant Datatype Check	Tests the attribute to verify if the user-specified datatype occurs more frequently than any other datatype
Range Check	Checks the attribute value against a range specified with a threshold
Schema Datatype Check	Compares the attribute value of an inferred datatype (determined by the most often occurring datatype) against the datatype specified in the schema. Valid values are: String, Decimals, Integers and Nulls.
Schema Length Check	Compares the attribute value of longest length against the length specified in the schema.
Spaces Check	Checks the attribute values for spaces against a specified threshold
Sum Check	Totals all values of the attribute and compares the results against a specified value
Uniqueness Check	Compares uniqueness of the attribute against a specified threshold
Values Check	Checks the attribute's valid and invalid values against a specified threshold

Note the following default behavior:

Only Null Check and Schema Datatype Check ABRs are enabled by default.
Spaces and Uniqueness ABRs have thresholds set to 95%, all others are set at 100%.
All default ABRs are automatically associated with the lowest numeric priority available in the repository. This default priority can be modified at any time.
When working with the Predominant Datatype Check, to avoid introducing errors in expressions, add or edit the Decimal, Integer, and String literals by using the Literals > Type list in the Expression Builder. This allows you to add the properly formatted datatype value to your expression.