Page Operations
Browse SpaceDescription
This step is used to read data from a fixed width file
Options
The table below describes the options available for the Fixed File Input step:
| Option | Description |
|---|---|
| Step name | Name of the step.
|
| Filename | Specify the name of the CSV file to read from. |
| Line width in bytes | Specify the width of each record in the target file. This is the width excluding the carriage return or linefeed fields. |
| Line feeds present? | Check if the target file contains line feed characters. |
| NIO buffer size | This is the size of the read buffer. It represents the amount of bytes that is read in one time from disk. |
| Lazy conversion | The lazy conversion algorithm will try to avoid unnecessary data type conversions and can result in a significant performance improvements if this is possible. The typical example that comes to mind is reading from a text file and writing back to a text file. Check to enable. |
| Header row present? | Enable this option if the target file contains a header row containing column names. |
| Running in parallel? | Check this box if you will have multiple instances of this step running (step copies) and if you want each instance to read a separate part of the file. |
| File Encoding | Specify the encoding of the file being read. |
| Add filename to result |
Adds the filename(s) read to the result of this transformation. A unique list is being kept in memory that can be used in the next job entry in a job, for example in another transformation. |
| Fields Table | This table contains an ordered list of fields to be read from the target file. |
| Preview button | Click to preview the data coming from the target file. |
| Get Fields button | Click to return a list of fields from the target file based on the current settings (i.e. Delimiter, Enclosure, etc.). All fields identified will be added to the Fields Table. |