Select a connection from the list.

Data Integration Hub

deletes the files after it reads them. You must have permissions on the remote server to delete the files.

Description name of the source. The name identifies the source when you configure field mapping for the publication.

Name of the file that

Data Integration Hub

picks up and publishes to the publication repository.

The file name can include asterisk wildcards and variables. Enter variables in the following format:

($pattern)

. For example:

Input_($PublicationName)_($sequence).in

.

Select one of the following options:

Topic Table. Select the topic table that represents the structure of the flat file.
Sample file. A sample file that represents the structure of the flat file. Browse to select and upload the file.

Expand the

File Format

area to view and edit the format of the file. Changing the file format might affect the column structure.

Code page

Character encoding used in the file.

Number of initial rows to skip

Number of rows at the beginning of the file that

Data Integration Hub

ignores when it reads the file.

Data Integration Hub

published only the subsequent rows.

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

.

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.

Thousands Separator

Optional. Symbol used in the file as a thousands separator.

Decimal Separator

Symbol used in the file as a decimal separator.

Datetime Format

Date and time format used in the file. Select a predefined format or select

Other

to define a custom format. For information about the supported datetime formats, see the

PowerCenter Transformation Language Reference

.

The datetime format can contain up to 50 characters.

The column structure depends on the file format settings that you configure in the

File Format

area. The table must contain at least one column.

Column Name

Must begin with an alphabetic character or an underscore and can contain only alphanumeric characters and underscores.

If you select the option

Import column names

,

Data Integration Hub

populates the column names with the strings of the defined row. If you do not select the option

Import column names

,

Data Integration Hub

assigns default names to the columns. For example,

Field1

,

Field2

,

Field

n

.

Data Type

Select from the list of available data types. By default,

Data Integration Hub

reads the data as string.

Precision

Enabled only for data types that support precision.

Scale

Enabled only for data types that support data scaling.

If you select a sample file that represents the structure of the flat file, this area shows the data in the sample file. The

Preview

area presents the data in the structure that

Data Integration Hub

applies when it distributes the data into topic fields in the topic table, according to the

File Format

parameters.