Informatica Data Quality
- Informatica Data Quality 10.4.1
- All Products
Property
| Description
|
---|---|
Delimiters
| Character used to separate columns of data.
Click the Delimiters field to select a character or to assign a parameter to the property. Delimiters must be printable characters and must be different from the text qualifier and the escape character if selected.
Default is Comma.
|
Text qualifier
| Quote character that defines the boundaries of text strings. If you select a quote character, the Developer tool ignores delimiters within a pair of quotes.
Default is No Quotes.
|
Start import at line
| Row at which the Data Integration Service starts importing data. Use this option to skip header rows.
Default is 1.
|
Row delimiter
| Octal code for the character that separates rows of data. Default is line feed, \012 LF (\n).
The row delimiter applies to reading source data. When the Data Integration Service writes to a target file, it always uses the default delimiter, \n.
|
Escape character
| Character used to escape a delimiter character in an unquoted string if the delimiter is the next character after the escape character. If you specify an escape character, the Data Integration Service reads the delimiter character as a regular character embedded in the string.
You can improve mapping performance slightly if the source file does not contain quotes or escape characters.
|
Retain escape character in data
| Includes the escape character in the output string.
Default is disabled.
|
Treat consecutive delimiters as one
| Causes the Data Integration Service to treat one or more consecutive column delimiters as one. Otherwise, the Data Integration Service reads two consecutive delimiters as a null value.
Default is disabled.
|