Metadata Functions - trillium_discovery - Latest

Trillium Expression Builder

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Expression Builder
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T14:57:33.223822

The functions for the Metadata category refer to attribute metadata values. Use expression qualifiers to verify the expected attribute value. If the attribute metadata has not been analyzed (for example, when the data is not loaded), the function verifies a default value based on the metadata type.

Function Name

Description

AVERAGE

Verifies the numeric average for all rows of an attribute in a entity (data source).

Note: Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources). Not supported for Quality processes.
INFERRED_TYPE

Verifies a value as integer, decimal, or string datatype. Evaluation is based on the majority of values of that particular datatype across the full data set.

Note: Analyze the entity (data source) before running this function. This function is not supported for dynamic entities (data sources). Applicable only to real, fully- loaded entities (data sources).
PATTERN_STYLE

Verifies whether an attribute has the default pattern style 1.

Note: Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).Not supported for Quality processes; when used in Quality, the function returns a dash (-).
SCHEMA_LENGTH

Compares an integer value representing the expected maximum length of an attribute against the length as defined in the schema.

Note: Analyze the entity (data source) before running this function. Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources). SCHEMA_LENGTH returns the length in bytes; LENGTH returns the length in characters.
SCHEMA_TYPE

Verifies the schema definition of an attribute.

Note: Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
SUM

Verifies the sum of values within an attribute against a supplied value.

Note: Function is supported for profiling processes. Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).