PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5.4
- 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 source object.
You can select one of the following options:
Character used to separate the rows of data. You must select the default value,
\012 LF (\n).
Header Line Number
Line number that you want to use as the header.
You can also read a data from a file that does not have a header. To read data from a file with no header, specify the value of the Header Line Number field as 0.
First Data Row
Line number from where you want the Data Integration Service to read data.
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.
True or false. Default is true.
\012 LF (\n).
A string value. Default is