List of Summary Items - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008
Information in the Metadata Summary View varies depending on the object you select in the Navigation View. The following tables list the summary data items displayed for each object. See How to Use Summary Data Views.

Projects and Processes

Project Type

Summary Data

Baseline Analysis

  • Project properties— name, description, entities, permanent/discovered joins, all joins
  • Control metadata—date created, created by, edited by, date changed

Time Series Analysis

  • Name, Schema name, Attributes, Rows, Values, Enabled business rules, Connection data, Encoding, Schema, Permanent keys, Permanent dependencies, Permanent joins, Source type, Delimiter, Quote characters

Quality

  • Project properties—project reference ID, description, countries, project type
  • Control metadata—created by, created date, last modified by, last modified date
  • Entity row counts—number of rows in each entity in the project
  • Project process status—process status for each process

Process (Quality projects)

  • Process properties—name, description, ID, type
  • Control metadata—created date, created by, run date
  • Process report files—control file, log file, statistics file, graphical statistics file, settings file (STX). See Viewing Process Report Files for the descriptions of process report files.

Entities

Category

Summary Data

Content Summary

  • Entity completeness

Structural Summary

Relationship Summary

Statistical Summary
  • Whisker chart for statistical analysis of numeric attributes
  • Mean, median, mode, count, percentile, rank

About

  • Entity properties—name, type, state, business description, status in project, internal entity reference, connection data, row count, included in project(s)
  • Source properties—data source, source type, attribute count
  • Control metadata—analyzed date, analyzed by

Attributes

Category

Summary Data

Content Summary

  • Distribution of distinct values, patterns, masks, soundexes, and metaphones.
  • Completeness—schema null rule, null count, null distribution %, space count, space distribution %, variable spaces
  • Validity—min/max value, value distribution %, metaphone count, soundex count
  • Consistency—mask count, pattern count

Structural Summary

  • Data type distribution—strings, decimals, integers
  • Attribute structural details—min/max length, inferred data type, target data type, schema name, inferred precision, inferred scale
  • Attribute data type distribution details—count, distribution %, and min/max value for each data type

Relationship Summary

  • Permanent/discovered joins, keys, and dependencies, baseline analysis data type
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—populated, non-populated
  • Attribute business rules total compliance—name, reference ID, attribute rule compliance %