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

Add Table from PowerCenter Workflow

Add Table from PowerCenter Workflow

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.

0 COMMENTS

We’d like to hear from you!