PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5.1
- All Products
Property
| Description
|
---|---|
Maximum row to preview
| Number of rows to show in data preview. Default is 0.
|
Delimiters
| 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.
|
Text Qualifier
| 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 Mode
| Qualifier behavior for the source object.
You can select one of the following options:
|
Row Delimiter
| 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.
|
Escape Character
| 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
| Not applicable.
|
Property
| Value
|
---|---|
maxRowsToPreview
| A positive integer value.
Default is 0.
|
delimiter
| 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.
|
textQualifier
| Specify the following string values:
Default is double quotes.
|
importColumnFromFirstLine
| True or false. Default is true.
|
rowDelimiter
| Default value,
\012 LF (\n) .
|
escapeCharacter
| A string value. Default is
\ .
|