Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Object Import and Export
  12. Data Type Reference
  13. Keyboard Shortcuts
  14. Connection Properties

Developer Tool Guide

Developer Tool Guide

Control File Formats

Control File Formats

Delimited and fixed-width flat files have different control file formats. You can use control files to generate column metadata at run time or to create a flat file data object.
Use one of the following formats to create a control file:
Delimited control file
Each line in a delimited control file has the following format:
[column name],<data type>,<precision>,<scale>
The following example shows a delimited flat file control file:
Dept,String,10 Name Place,String,20 Country Phone number,string,30
Fixed-width control file
Each line in a fixed-width control file has the following format:
[column name],<data type>,<precision>,<scale>,<number of bytes to process>
The following example shows a delimited flat file control file:
Dept,String,10 Name Place,String,20 Country Phone number,string,30
For a fixed-width source, the control file contains an additional column for the number of bytes to process. If you do not specify the number of bytes to process, the Data Integration Service uses the value specified for the precision as the number of bytes to process.

0 COMMENTS

We’d like to hear from you!