PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5
- 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 target object.
You can select one of the following options:
Default is minimal.
|
Row Delimiter
| Character used to separate the rows of data.
The default value is
\012 LF (\n) .
|
Target Header
| Indicates whether you want to write data with or without a header.
|
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.
|
rowDelimiter
| Default value,
\012 LF (\n) .
|
escapeCharacter
| A string value. Default is
\ .
|