Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Industry data service customizer
  9. Intelligent structure models
  10. Refining intelligent structure models
  11. Mapplets
  12. Saved queries
  13. Shared sequences
  14. 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.

0 COMMENTS

We’d like to hear from you!