Operator Guide

Back Next

Adding a Topic Table from a Flat File

Add a table to the topic structure from a sample flat file. You can only use delimited files to add a topic table.

In the

Structure

page of the

New Topic

wizard, click

Add Tables

and then select

From Flat File

The

Add Table from File

wizard appears, showing the

Definition

page.

Click the browse button next to

Sample file

The

Sample File

dialog box appears.

Click

Browse

, select the file, and then click

Upload

The

Sample File

dialog box closes.

In the

File Format

area, define the following parameters:

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.

The

Preview

area shows the columns in the table.

Click

The

Structure

page of the

Add Table from File

wizard appears.

Review the table structure and adjust it if required. The following list describes the elements of the

Structure

page of the

Add Table from File

wizard:

Table Name: Name of the table. By default,
Data Integration Hub
derives the table name from the name of the file that you select in the
Definition
page. You can edit the default name.
The table name can contain only ASCII alphanumeric characters and underscores and cannot start with a numeric character.

The name must be unique in the
Data Integration Hub
publication repository.
Column table: Use the add, up, down, and remove buttons to add, order, and remove table columns. The table must contain at least one column.
Each column must contain the following information:
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
in the
Definition
page,
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
,
Fieldn
.

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.
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.