Flat File Data Sources - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

Trillium can import or link to data from any of the following flat file data source:

  • Flat files: Fixed-length files described by a schema. Includes those files created by Trillium Quality processes in the Control Center.
    Note: Duplicate row ID (formerly checksum) calculation, sparse row counting, and row length statistics are not supported for Trillium connections.
  • Delimited files
    • With ASCII, extended ASCII, or hexadecimal delimiters

    • With or without ANSI SQL DDL

  • COBOL flat fixed length files

    • Data must match copybook layout

    • Various character encoding including ASCII, EBCDIC, and Unicode

    • Big or little Endian byte orders

    • One- or two-byte data alignment

    • Common COBOL copybook features such as:

    • REDEFINES clause

    • OCCURS clause

    • FILLER clause

    • COBOL data types: 9, X, A, B

    • Numeric storage formats: COMP-3, Packed-DECIMAL, COMP, COMPUTATIONAL, or BINARY

    • Comments beginning with *

    • Descriptors such as USAGE IS, DISPLAY, SEPARATE, LEADING, and TRAILING

    • Unnamed fields

    • Unsigned COMP-3 fields
      Note: Copybook features such as Multiple Record Types and OCCURS DEPENDING must be manually removed from the Copybook and the data file prior to loading into the Trillium.
      Note: For more information about supported and unsupported COBOL copybook features, see COBOL Copybooks.