Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Create Table Properties

When you define the structure of the topic by creating a table, you name the table.

For topics that use a relational database or a Hadoop publication repository, you also configure the table columns.

The

Create Table

page contains the following properties:

Table Name: Logical name of the table. Can contain only ASCII alphanumeric characters and underscores. Cannot start with a numeric character.
The name must be unique in the
Data Integration Hub
publication repository.
Physical Table Name: Physical name of the table. Can contain only ASCII alphanumeric characters and underscores. Cannot start with a numeric character.
The name must be unique in the
Data Integration Hub
publication repository.
Table Description: Optional description of the table.
Apply Delta Detection: Data Integration Hub
detects the delta between the current publication event and the previous publication event.
Data Integration Hub
applies the delta that it detects in publications to subscriptions that consume the data from a relational database topic with the delivery option
Insert new rows and update changed rows
.
Data Integration Hub
applies delta detection to tables for which a primary key is defined. You assign primary keys to tables in the
Table Relations
tab of the topic wizard.
Column table: For topics that use a relational database or a Hadoop publication repository, use
the add, up, and down buttons to add and order table columns. You must add at least one column to the table. For each column, enter the following information:

Column Name. Logical name of the column. Must begin with an alphabetic character or an underscore and can contain only alphanumeric characters and underscores.
Physical Name. Physical name of the column. Must begin with an alphabetic character or an underscore and can contain only alphanumeric characters and underscores.
Data Type. Select from the list of available data types.
Precision
.
Enabled only for data types that support precision.

Scale
.
Enabled only for data types that support data scaling.

Description. Optional description of the column.

For topics that use a file publication repository,
Data Integration Hub
defines the tables and columns that hold the file metadata and you can only edit the precision field.

Data Integration Hub

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

Structure Preview

area of the

Structure

page of the topic wizard.

Create a Table

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal