Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

File Table Structure Properties

Use the

Structure

page of the

Add Table from Flat File

wizard to review the table structure and to adjust it if required.

The

Structure

page of the

Add Table from Flat File

wizard includes the following elements:

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.

Data Integration Hub

adds the columns DIH_PUBLICATION_INSTANCE_DATE, DIH_PUBLICATION_INSTANCE_ID, and DIH__UPDATE_STRATEGY_FLAG to the table. When you finish adding the table, the columns show in the

Structure Preview

area of the

Structure

tab of the

Topic

wizard.

Add a Table from Flat File

Download Guide

Watch

Comments

Communities

Knowledge Base