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. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

Flat File Data Object Overview Properties

Flat File Data Object Overview Properties

The Data Integration Service uses overview properties when it reads data from or writes data to a flat file. Overview properties include general properties, which apply to the flat file data object. They also include column properties, which apply to the columns in the flat file data object. The Developer tool displays overview properties for flat files in the
Overview
view.
The following table describes the general properties that you configure for flat files:
Property
Description
Name
Name of the flat file data object.
Description
Description of the flat file data object.
The following table describes the column properties that you configure for flat files:
Property
Description
Name
Name of the column or the file name column port.
Native type
Native datatype of the column.
Bytes to process (fixed-width flat files)
Number of bytes that the Data Integration Service reads or writes for the column.
Precision
Maximum number of significant digits for numeric datatypes, or maximum number of characters for string datatypes. For numeric datatypes, precision includes scale.
Scale
Maximum number of digits after the decimal point for numeric values.
Format
Column format for numeric and datetime datatypes.
For numeric datatypes, the format defines the thousand separator and decimal separator. Default is no thousand separator and a period (.) for the decimal separator.
For datetime datatypes, the format defines the display format for year, month, day, and time. It also defines the field width. Default is "A 19 YYYY-MM-DD HH24:MI:SS."
Visibility
Determines whether the Data Integration Service can read data from or write data to the column.
For example, when the visibility is Read, the Data Integration Service can read data from the column. It cannot write data to the column.
For flat file data objects, this property is read-only. The visibility is always Read and Write.
Description
Description of the column.

0 COMMENTS

We’d like to hear from you!