Examining Data Types - trillium_discovery - 17.1

Trillium Discovery Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Discovery
Title
Trillium Discovery Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

When you load data into a data source, Discovery Center automatically calculates two types of statistics to represent your data:

  • Inferred. Derived from the full volume of data in the attribute.
  • Target. Required to hold all existing values in the current (target) attribute.

Each data source attribute has a target and inferred data type of either integer, decimal, or string depending on the structure of the data.

You examine data types for a single attribute by drilling down from an attribute's Structure > Data Type pie chart. You can also see the target and inferred data types for all attributes in a data source from the Attribute Summary tab.

To drill down from an attribute's Structure > Data Type pie chart

  1. Open a data source.
  2. Click Attribute Details.
  3. In the Attribute Name list, select the attribute whose data types you want to examine. The Structure > Data Type pie chart graphically shows the distribution of data types in the attribute. The chart's key lists the data types found and their distribution percentage in the attribute. An attribute's data may consist of a single data type or a combination of types. If there are no values found in some rows of the attribute, the percentage of these rows shows as Null.
  4. Hover over the chart sections to see the value count for the data type. Nulls display the row count.
  5. Double-click a section of the chart. A tab opens showing the attribute values for the data type selected. If you click a Null section, a tab opens showing the data rows that contain the empty data values for the current attribute.
  6. To open a tab that shows the data rows that contain the string, integer, or decimal values, double-click a row on the Strings: attribute_name, Decimals: attribute_name, or Integers: attribute_name tab.

See data type categories for all attributes in a data source

To see data type categories for all attributes in a data source

  1. Open a data source.
  2. Click the Attribute Summary tab. Note the values in the Inferred Datatype and Target Datatype columns.