User Guide

Back Next

Configuring a Schema for Flat Files

Configure schema for flat files when you configure column projection properties.

On the

Column Projection

tab, enable column projection and select the flat schema format.

The page displays the column projection properties page.

On the column projection properties page, configure the following properties:

Sample Metadata File. Select a sample file.

Code page. Select the UTF-8 code page.

Format. Format in which the source processes data. Default value is Delimited. You cannot change it.

Click

In the delimited format properties page, configure the following properties:

Property	Description
Delimiters	Specify the character that separates entries in the file. Default is a comma (,). You can only specify one delimiter at a time. If you select Other and specify a custom delimiter, you can only specify a single-character delimiter.
Text Qualifier	Specify the character used to enclose text that should be treated as one entry. Use a text qualifier to disregard the delimiter character within text. Default is No quotes. You can only specify an escape character of one character.
Preview Options	Specify the escape character. The row delimiter is not applicable as only one row is created at a time.
Maximum rows to preview	Specify the rows of data you want to preview.