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

Format Properties

Format Properties

The Developer tool displays format properties for flat file data objects in the
Format
section in the
Advanced
view.
The following table describes the format properties that you configure for flat file data objects:
Property
Description
Code page
Code page of the flat file data object.
For source files, use a source code page that is a subset of the target code page. For lookup files, use a code page that is a superset of the source code page and a subset of the target code page. For target files, use a code page that is a superset of the source code page
Default is "MS Windows Latin 1 (ANSI), superset of Latin 1."
Datetime format
Defines the display format and the field width for datetime values.
Default is "A 19 YYYY-MM-DD HH24:MI:SS."
Thousand separator
Thousand separator for numeric values.
Default is None.
Decimal separator
Decimal separator for numeric values.
Default is a period (.).
Column Format
Format for the flat file, either delimited or fixed-width.

0 COMMENTS

We’d like to hear from you!