Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Step 3. Create Topic Data Structure

Create and preview the data structure of the topic in the

Structure

page of the

New Topic

wizard.

You can use one or more of the following methods to add tables to the topic:

Add tables from a database: Use this method if the structure of the data domain that the topic represents exists in a database in your organization. For example, if the structure exists in one of the applications that publish to the topic.
Add tables from Enterprise Data Catalog: Use this method when the structure of the data domain that the topic represents exists in Enterprise Data Catalog. Select tables from an Enterprise Data Catalog asset that the
Data Integration Hub
topic must use.
Add a table from a flat file: Use this method when the structure of the data domain that the topic represents exists in a flat file. You can only use delimited files to add a topic table with this method.
Add tables from a PowerCenter workflow: Use this method if your organization has a PowerCenter workflow that extracts data from the source applications, and the targets of the workflow represent the structure in which you want to keep the data. The developer creates the workflow in PowerCenter Workflow Manager.
Data Integration Hub
generates the topic structure based on the targets in the workflow.
Add tables from a Metadata file: Use this method when the structure of a table in the data domain that the topic represents exists in a JSON, XML, XLS, or XLSX file.
Create a table: Use this method when the structure of the data domain that the topic represents does not exist in a database in your organization, in a PowerCenter workflow, or in a file, and you want to define the structure manually in
Data Integration Hub
.

You must add at least one table to the topic structure.

Click

Add Tables

and then select the method by which to add the tables to the structure.

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.

Click

The

Table Relations

page appears.

Creating a Topic with a Relational Database Publication Repository

Adding Topic Tables from a Database

Adding Tables from Enterprise Data Catalog

Adding a Topic Table from a Flat File