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:
|
||