Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

File Table Definition Properties

Use the

Definition

page of the

Add Table from Flat File

wizard to select the file that contains the structure of the data domain that the topic represents, to configure the file format, and to preview the file.

The

Definition

page of the

Add Table from Flat File

wizard includes the following elements:

File: Location and name of the file that contains the structure of the data domain that the topic represents. You can browse to select the file.
Code page: Character encoding used in the file.
Import column names: Optional. Select
Yes
to use the column names in the file as the default column headers in the table. Enter the number of the row that serves as the file's header row in
From row
.
Default text length: Optional. Length of the text fields in the table.
Delimiter: Delimiter used in the file to separate between columns. Select a predefined delimiter or select
Custom
to define a custom delimiter.
For information about the supported column delimiters, see the sections about importing delimited flat files and about updating delimited file properties in the
PowerCenter Designer Guide
.
Text qualifier: Optional. Symbols used in the file to enclose a string.
Preview: This area shows the columns in the table. If you select a sample file that represents the structure of the flat file, this area shows the data in the sample file.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

File Table Definition Properties

File Table Definition Properties