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

Column Format: Delimited Properties

Column Format: Delimited Properties

When the flat file is delimited, the Developer tool displays delimited properties in the
Column Format: Delimited
section in the
Advanced
view.
The following table describes the delimited properties that you configure for flat file data objects:
Property
Description
Delimiters
Character used to separate columns of data.
Click the Delimiters field to select a character or to assign a parameter to the property. Delimiters must be printable characters and must be different from the text qualifier and the escape character if selected.
Default is Comma.
Text qualifier
Quote character that defines the boundaries of text strings. If you select a quote character, the Developer tool ignores delimiters within a pair of quotes.
Default is No Quotes.
Start import at line
Row at which the Data Integration Service starts importing data. Use this option to skip header rows.
Default is 1.
Row delimiter
Octal code for the character that separates rows of data. Default is line feed, \012 LF (\n).
The row delimiter applies to reading source data. When the Data Integration Service writes to a target file, it always uses the default delimiter, \n.
Escape character
Character used to escape a delimiter character in an unquoted string if the delimiter is the next character after the escape character. If you specify an escape character, the Data Integration Service reads the delimiter character as a regular character embedded in the string.
You can improve mapping performance slightly if the source file does not contain quotes or escape characters.
Retain escape character in data
Includes the escape character in the output string.
Default is disabled.
Treat consecutive delimiters as one
Causes the Data Integration Service to treat one or more consecutive column delimiters as one. Otherwise, the Data Integration Service reads two consecutive delimiters as a null value.
Default is disabled.

0 COMMENTS

We’d like to hear from you!