Informatica Data Quality
- Informatica Data Quality 10.5.1
- All Products
Property
| Description
|
---|---|
Delimiters
| Character used to separate columns of data. 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. 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. The Developer tool prefixes "FIELD_" to field names that are not valid.
|
Row Delimiter
| Specify a line break character. Select from the list or enter a character. Preface an octal code with a backslash (\). To use a single character, enter the character.
The Data Integration Service uses only the first character when the entry is not preceded by a backslash. The character must be a single-byte character, and no other character in the code page can contain that byte. Default is line-feed, \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.
|
Start Import at Line
| Row number at which the Data Integration Service starts reading when it imports the file. For example, if you specify to start at the second row, the Developer tool skips the first row before reading.
|
Treat Consecutive Delimiters as One
| If selected, the Data Integration Service reads one or more consecutive column delimiters as one. Otherwise, the Data Integration Service reads two consecutive delimiters as a null value.
|
Retain Escape Character in Data
| Includes the escape character in the output string.
|
Property
| Description
|
---|---|
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.
|
Start Import at Line
| Row number at which the Data Integration Service starts reading when it imports the file. For example, if you specify to start at the second row, the Developer tool skips the first row before reading.
|
Column breaks
| Configures the column breaks in the fixed-width file. Click
Edit Breaks to edit column breaks. Or, follow the directions in the wizard to manipulate the column breaks in the file preview window. You can move column breaks by dragging them. Or, double-click a column break to delete it.
|