PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.4.0
- 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.
|
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.
|
Import Column Names From First Line
| If selected, the Developer tool uses data in the first row for column names. Select this option if column names appear in the first row. Default is true.
|
Row Delimiter
| You must select the default value,
\012 LF (\n) .
|
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.
|
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
\ .
|