Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Subscription Field Mapping Properties

The

Field Mapping

page of the subscription wizard can include the following properties:

Field Mapping: Shows the total number of tables in the topic, which is associated with the subscription, and the number of tables that are mapped.
Auto Map: Data Integration Hub
maps the tables and fields according to table and field names. If a table name or a field name in the target is identical to a name in the topic,
Data Integration Hub
maps between the tables or the fields.
Data Integration Hub
does not map tables and fields that do not match, and you can manually map them.
Clear All: Clears table and field mapping.
The subscription must contain at least one mapped target table.
Mapping table: Lists all tables in the topic, which is associated with the subscription, and the target tables to which the topic tables are mapped. Use the mapping table to manually map topic tables to target tables, to map topic fields to target fields, and to clear the mappings.
Each line in the mapping table contains the following elements:

Topic Table. Name of the topic table and the number of fields in the topic table.
Mapped Target Table. Name of the target table and the number of fields in the target table.
Mapped Fields. Number of fields that are mapped between the topic table and the target table.
Edit Table Mapping. Click the edit icon to edit the table mapping. For more information, see the section "Edit Table Mapping for Subscriptions".
This option is disabled for subscriptions with a flat file source.

Edit Field Mapping. Click the edit icon to edit the field mapping. A topic table must be mapped to a target table before you can edit the field mapping of the table. For more information, see the section "Edit Field Mapping for Subscriptions".
Clear Mapping. Clear the mapping between the topic table and the target table.

If the target does not contain any of the topic tables or if the selected connection does not contain metadata access details,
Data Integration Hub
generates the subscription mapping based on the topic tables, and the table mapping and field mapping editing options are disabled. To change the default mapping, click
Clear All
, and then edit the table and field mapping.