How Value Lengths are Calculated - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

When Trillium Software System imports data, it calculates the minimum and maximum lengths for both rows (records/rows) and attributes (fields/columns).

Minimum and maximum length calculations occur after the loader process (flat file loader connections, such as COBOL and TSQ files) removes trailing spaces from a value. These values are shown in the "Trunc" and "Trunc Dist %" metadata in the metadata List View of the current attribute.

The following table shows examples of how value lengths are calculated:

ATTR1

Length

Truncation Rule

/p/j/k 55

3

Trailing spaces truncated

FRED

4

No change

FRED555

4

Trailing spaces truncated

555

1

Keep one space; remove the rest

LEGEND:

  • The symbol 5 represents a space character.
  • The symbol /p represents an unprintable character.
Note: Minimum and maximum length calculations for delimited files do not remove trailing spaces from a value.