For topics that use a relational database or a Hadoop publication repository, define the structure of the topic by extracting tables from a PowerCenter workflow.
To extract tables from a PowerCenter workflow, you must select either a PowerCenter workflow or a workflow definition file that the developer exported from PowerCenter.
Data Integration Hub
generates the topic structure based on the targets in the workflow.
When
Data Integration Hub
creates the topic tables in the publication repository, it might change the table names and the column names that you assign when you create the topic.
If you want to use the same workflow for a publication with custom mappings, you must first verify that the target tables in the workflow are identical to the topic target tables that
Data Integration Hub
generated on the
Data Integration Hub
publication repository. If required, update the tables in the workflow. For more information, see
Topic Table and Column Names.