PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5
- All Products
Maximum row to preview
Number of rows to show in data preview. Default is 0.
Character used to separate columns of data. Default is comma. If you enter a delimiter that is the same as the escape character or the text qualifier, you might receive unexpected results. You cannot specify a multibyte character as a delimiter.
Quote character that defines the boundaries of text strings. Default is double quotes. If you select a quote character, the Developer tool ignores delimiters within pairs of quotes.
Qualifier behavior for the target object.
You can select one of the following options:
Default is minimal.
Character used to separate the rows of data.
The default value is
\012 LF (\n).
Indicates whether you want to write data with or without a header.
Character immediately preceding a column delimiter character embedded in an unquoted string, or immediately preceding the quote character in a quoted string. When you specify an escape character, the Data Integration Service reads the delimiter character as a regular character. Default is backslash (\).
Retain Escape Character in Data
A positive integer value.
Default is 0.
Specify the octal code for the character. Preface the octal code with a backslash (\). Specify the following values for the given delimiters:
Default is comma.
You cannot specify a multibyte character as a delimiter
Specify the following string values:
Default is double quotes.
\012 LF (\n).
A string value. Default is
Updated August 17, 2021