For data that comes from a fixed-width text file, which data source type should be used?

For data that comes from a fixed-width text file, which data source type should be used?

• A. Fixed File
• B. Delimited File
• C. Connector
• D. Data Management Export Sequence

Answer: (A)

When a file uses fixed-width fields, you need a data source that can interpret data by character positions rather than by a delimiter. A Fixed File data source is designed for this: you specify the exact start position and width for each field, so every value maps to the correct dimension, account, or attribute in OneStream. This makes parsing reliable even if there are no separators between fields. Delimiters would require a Delimited File data source, which isn’t appropriate for fixed-width layouts. A Connector is used for live connections to external systems or services, not for parsing a static fixed-width file. Data Management Export Sequence is for exporting data out of OneStream, not for ingesting fixed-width input.

When a file uses fixed-width fields, you need a data source that can interpret data by character positions rather than by a delimiter. A Fixed File data source is designed for this: you specify the exact start position and width for each field, so every value maps to the correct dimension, account, or attribute in OneStream. This makes parsing reliable even if there are no separators between fields.

Delimiters would require a Delimited File data source, which isn’t appropriate for fixed-width layouts. A Connector is used for live connections to external systems or services, not for parsing a static fixed-width file. Data Management Export Sequence is for exporting data out of OneStream, not for ingesting fixed-width input.