Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Catalog
  4. Applications
  5. Topics
  6. Creating Topics
  7. Topic Properties
  8. Publications
  9. Creating Publications
  10. Publication Properties
  11. Subscriptions
  12. Creating Subscriptions
  13. Subscription Properties
  14. Events and Event Monitoring
  15. Dashboard and Reports
  16. Glossary

Operator Guide

Operator Guide

Creating a Topic Table

Creating a Topic Table

Add a table to the topic structure by creating the table.
  1. In the
    Structure
    page of the
    New Topic
    wizard, click
    Add Tables
    and then select
    Create
    .
    The
    Create Table
    page appears.
  2. Enter the logical table name in the
    Table Name
    field.
  3. If required, change the physical table name.
  4. Optionally, enter a description of the table.
  5. Use the add, up, and down buttons to add and order table columns. You must add at lease 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.
    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.
  6. Click
    OK
    .
    The
    Create Table
    page closes. The
    Structure
    page shows the topic table and a preview of the topic structure.

0 COMMENTS

We’d like to hear from you!