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

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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.