Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

Fixed-width file formats

Fixed-width file formats

You can create and save fixed-width file formats that specify the formatting details for fixed-width flat files.
You can use a fixed-width flat file as a source or target in mappings and
mapping
tasks. When you select a flat file connection for a Source transformation or Target transformation, you specify the flat file type. If you select the fixed-width flat file type, you select the most appropriate fixed-width file format to use based on the data in the fixed-width flat file.
You can create multiple fixed-width file formats. For example, you might have a fixed-width file format to use for fixed-width flat files that contain quarterly sales data and another fixed-width file format to use for fixed-width flat files that contain inventory data.
If a fixed-width file format does not already exist, you must create a fixed-width file format before you create a mapping or
mapping
task that uses a fixed-width flat file.
To configure a fixed-width file format, you specify the number of columns and the width, name, and datatype for each column. You can also set advanced fixed-width format properties. For example, you can specify how to handle null characters or specify the default date format for each column.
You can delete fixed-width file formats that you no longer use. You cannot delete a fixed-width file format that is used in a mapping or
mapping
task.


Updated August 03, 2020