Operator Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Step 5. View and Edit Publication Field Mapping

View the mapping of source tables and fields to topic tables and fields and edit field mapping on the

Field Mapping

page of the publication wizard. If you created joins in "Step 4. Define Joins", configure field mapping of joins and fields to topic tables and fields.

Perform the following actions to map a source table or a join to a topic table:

Click the edit table mapping icon.

The

Edit Table Mapping

dialog box appears.

Click the row of the table or join that you want to map and then click

Map Source Table

The

Edit Table Mapping

dialog box closes. The

Field Mapping

page shows the table you mapped in the

Mapped Source Logical Name

list.

Perform the following actions to configure, view, and edit the mapping of fields in a source table or in a join to fields in a topic table:

Click the edit field mapping icon.

The

Edit Field Mapping

dialog box appears.

Data Integration Hub

maps the fields automatically, according to name match.

To search for fields that are used in the topic table and the source table, enter a string for the field name in

Find Field

, and then click

. The search is not case sensitive. You can search for a substring.

Choose

Display unmapped fields only

to show only unmapped fields in the search results.

Source and topic fields that match the search string appear. A green checkmark next to a field name indicates that the field is mapped.

To map a source table field to a topic table field, drag the field from the

Source Table

section to the

Topic Table

section.

To add an expression to a 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.

To clear the mapping of a field, in the

Actions

column, click the clear icon.

To view field details, rest on the details icon to the left of a field name.

To revert to the default

Data Integration Hub

field mapping, click

Auto Map

Click

to apply the mapping.

The

Edit Field Mapping

dialog box closes.

To clear all table and field mapping, click

Clear All

in the

Field Mapping

page.

The publication must contain at least one mapped source table.

In the

Field Mapping

page, click

The

Filter

page appears.

Creating an Automatic Flat File Publication

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Step 5. View and Edit Publication Field Mapping

Step 5. View and Edit Publication Field Mapping