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 Field Mapping Properties for Subscriptions

Edit Field Mapping Properties for Subscriptions

To map fields in a table, select the target table field and the topic table field from the corresponding columns of the
Edit Field Mapping
dialog box and map them to each other.
The following list describes the elements of the
Edit Field Mapping
dialog box.
Find Field
Searches fields by name in both the topic table and the target table. Enter the string for which to search, and then click
Search
. The search is not case sensitive. You can search for a substring.
After you enter a string in the
Find Field
text box, you can click
X
to clear the search and show all fields.
Choose
Display unmapped fields only
to show only unmapped fields in the search results.
Auto Map
Data Integration Hub
maps the fields according to field names. If a name in the target is identical to a name in the topic,
Data Integration Hub
maps between the fields.
Data Integration Hub
does not map fields that do not match, and you can manually map them.
Clear All
Clears the field mapping. In subscriptions with a relational database target, fields that are not mapped will not be written to the subscribing database. In subscriptions with a flat file target, the target file will not include unmapped fields.
The table must contain at least one mapped field.
Topic Table
Lists the fields in the topic table that match your search. Mapped fields are denoted by a green checkmark. Select the field that you want to map.
Rest on the details icon to the left of a field name to view the details of the field.
Target Table
Lists the fields in the target table that match your search, and shows the mapping between the listed target fields and topic fields. Mapped fields are denoted by a green checkmark. Select the field that you want to map.
You can perform the following actions on a target field:
  • Add an expression to the field. In the
    Actions
    column, click the expression icon to open the
    Expression Editor
    , and then select fields and functions to add to the field.
  • Clear the mapping of the field. In the
    Actions
    column, click the clear icon.
  • View field details. Rest on the details icon to the left of a field name.

0 COMMENTS

We’d like to hear from you!