Data Representation - trillium_discovery - trillium_quality - 17.1

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

This topic explains how Trillium handles certain special characters when it imports data into a repository.

Unprintable Characters

Unprintable characters are control characters such as new lines, carriage returns, tabs, or binary zeros. Unprintable characters are not removed from the end of pure space values or values. They are displayed as the symbol Control Center's representation of an unrecognizable character (icon of a square) in Trillium. To find out the true value of these unprintable characters you will need to follow the steps below.

To find the actual value of an unprintable character ()

  1. In the Navigation View, right-click the attribute containing the unprintable characters and select Drill down to Metadata. The Entity Member Attribute List View for the selected attribute opens.
  2. Double-click Values.
  3. Locate the value.
  4. Right-click the value and select Detail Value. The character, hexadecimal, and decimal values are displayed for each character in that value.

Spaces

For data imported through a loader connection with a type of COBO L or TSQ, space characters are removed from the end of all values. For values that contain only space values, the value held in Trillium is always just one space character, with metadata tags to show the original shortest and longest space value for the entire attribute.

Spaces are represented in Trillium as blank values.

To find the actual value of a space

  1. In the Navigation View, right-click the attribute containing the space value and select Drill down to Metadata. The Entity Member Attribute List View for the selected attribute opens.
  2. Double-click Values.
  3. Locate the value.
  4. Right-click the value and select Detail Value. The character, hexadecimal, and decimal values are displayed for each character in that value.

Nulls

A null is the absence of a value. In delimited files, a null can occur where two delimiters follow each other with no data in between. For example, in the data fields customerx,,housenumber, the middle value is considered null. In RDBMS applications, nulls can be found in attributes that allow nulls. In COBOL, LOW VALUES are nulls.