Viewing Attribute Metadata - trillium_discovery - trillium_quality

Viewing Attribute Metadata - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Quality

Trillium > Trillium Discovery

Version

17.2

Language

English

Product name

Trillium Quality and Discovery

Title

Trillium Control Center

First publish date

2008

Last updated

2024-07-01

Published on

2024-07-01T08:56:48.630530

Attribute metadata is summary information about the data stored in an attribute (field/column). Trillium discovers metadata for each attribute in an entity. Viewing metadata allows you to better understand the content and structure of your data.

Note: A subset of attribute metadata, called derived metadata rules, are external to the attribute data and many are user-specified.

View metadata for an attribute in the following two ways:

In the Summary Data View of the selected attribute.
In a List View accessed from the Navigation View or the Summary Data View of the selected attribute.

Attribute Metadata Summary Data View

When you view attribute metadata in a Summary Data View, the following types of metadata are presented across four tabs:

Tab	Metadata
Content Summary	Distribution of distinct values, patterns, masks, soundexes, and metaphones. Completeness—schema null rule, null count, null dist%, space count, space dist%, variable spaces Validity—min/max, value dist%, metaphones, soundexes Consistency—masks, patterns, phrases
Structural Summary	Datatype distribution—strings, decimals, integers, nulls Structural details—min/max length, inferred datatype, target datatype, schema name, inferred precision, inferred scale Datatype distribution details—count, distribution %, min/max value for each datatype
Relationship Summary	Data relationship analysis—permanent/discovered joins, keys, and dependencies
Statistical Summary	Whisker chart and standard deviation chart for statistical analysis of numeric attributes Mean, median, mode, count, percentile, rank, standard deviation, statistical outliers
About	Percent populated chart—the percentage of attributes that contain data Attribute business rules total compliance—attribute name, reference ID, attribute business rule compliance %

Note: Each tab contains links you click to drill down to List Views of attribute metadata. For more information, see Summary Data Views.

When you open the Attribute Metadata Summary, by default, the Content Summary view opens.

To open the Summary Data View of attribute metadata

In the Navigation View, click the Discover bar, then click the Entities tab.
Expand an entity.
Click the attribute whose metadata you want to view.

The Summary Data View for the selected attribute displays. (If the view does not open, click the Metadata Summaries icon on the Home tab.)
Navigate through the Summary Data View tabs as needed to view attribute metadata.

Summary Data example:

The following graphic shows the Content Summary tab of a Summary Data View for the attribute Total Orders:

Attribute Metadata List View

When you view attribute metadata in a List View, the summary data is presented in rows across the following three columns:

Column	Metadata
Metadata	The name of the attribute.
Value	The value associated with the metadata. For example, the attribute name, the number of patterns and masks discovered in the attribute, and whether the attribute datatype is decimal, integer, or string.
Description	A description of the metadata statistic.

To open a List View of attribute metadata

In the Navigation View, click the Discover bar, then click the Entities tab.
Expand an entity.
Right-click an attribute whose metadata you want to view.
Select Drill down to metadata.

The Entity Member Attribute List View displays for the selected attribute.
Right-click a row to see a context menu of tasks you can perform, such as drilling down for more information, opening detail values, bookmarking the attribute for future reference, and exporting one or all attribute rows to a local or server system.

See attribute metadata List View example:

The following example shows a metadata List View for an attribute named Policy Number, sorted by alphabetical order. Available metadata depends on the content of the attribute and the results of data discovery.