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

Edit Table Mapping Properties for Relational Database Publications

Edit Table Mapping Properties for Relational Database Publications

To map a join table to a topic table, select the table from the join table list and map it to the topic table. To map a source table to a topic table, find a source table and map it to the topic table.
The
Edit Table Mapping
dialog box for relational database publications can include the following properties:
Select a new table to map to the topic table
Select a join table to map to the topic table.
Find Source Table
Search for source tables in the database. Note the following guidelines:
  • To search for tables by table name, enter a string in the
    Find Source Table
    text box and then click
    Search
    .
  • To search for tables that use a schema other than the default schema, clear the option
    Show default schema only
    , enter a string in the
    Schema
    text box, and then click
    Search
    .
  • To clear the search results and show only tables that use the default schema, select the option
    Show default schema only
    and then click
    Show All
    .
  • The search is not case sensitive.
  • You can search for a substring.
Search Results
Lists the source tables that match your search and shows which source table is mapped to the topic table for which you edit the mapping. To map a different source table to the topic table, select a table from the
Source Table
list.
Map Source Table
Maps between the table that you select and the topic table, and closes the
Edit Table Mapping
dialog box.

0 COMMENTS

We’d like to hear from you!