Operator Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Publication Field Mapping Properties

The

Field Mapping

page shows the tables in the topic that is associated with the publication, and the mapping between topic tables and source tables.

For relational database publications, if you added joins to the publication, the

Field Mapping

page shows the joins in the new tables list. For flat file publications, if you added joins to the publication, by default, the

Field Mapping

page shows only topic tables. The

Field Mapping

page shows a join only after you configure table mapping for the join.

The

Field Mapping

page can include the following properties:

Field Mapping: Shows the total number of tables in the topic that is associated with the publication 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 source table name or field name 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 publication must contain at least one mapped source table.
Mapping table: Lists all the tables in the topic that is associated with the publication and the source tables that are mapped to the topic tables. Use the mapping table to manually map source tables to topic tables, to map source fields to topic fields, and to clear the mapping.
Each line in the mapping table contains the following elements:

Mapped Source Table or Mapped Source Logical Name. Name of the source or join and the number of fields in the table.
Topic Table. Name of the topic table to which the source table is mapped and the number of fields in the topic table.
Mapped Fields. Number of fields that are mapped between the source table and the topic table.
Edit Table Mapping. Click the edit icon to edit the table mapping. For more information, see Edit Table Mapping for Publications.
Edit Field Mapping. Click the edit icon to edit the field mapping. A source table must be mapped to a topic table before you can edit the field mapping of the table. For more information, see Edit Field Mapping for Publications.
Clear Mapping. Clear the mapping between the source table and the topic table.

For publications with a relational database source, if the source does not contain any of the topic tables or if the selected connection does not contain metadata access details,
Data Integration Hub
generates the mapping based on the topic tables. 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.