Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Step 4. View and Edit Publication Field Mapping

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

Field Mapping

page of the publication wizard. If you created joins in "Step 3. Select Publication Source", configure field mapping of joins and fields to topic tables and fields.

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

Click the edit table mapping icon.

The

Edit Table Mapping

dialog box appears.

Click the row of the 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 join you mapped in the

Mapped Source Table

list.

Go to Step 3 to map the fields in the join to fields in the topic table.

Perform the following actions to view and edit the mapping of a source table to a topic table:

Click the edit table mapping icon.

The

Edit Table Mapping

dialog box appears.

Search for 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

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

To clear the search results and to 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.

The

Search Results

section displays the source tables that match the search string and the schema that each table uses. The name of the topic table for which you are editing the mapping shows in the row of the source table that is mapped to the topic table, in the

Mapped To

column.

To map a different source table to the topic table, click the row of the source table that you want to map and then click

Map Source Table

The

Edit Table Mapping

dialog box closes. The

Field Mapping

page shows the revised mapping.

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.

To search for fields that are used in the topic table and in 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

To clear all field mappings, click

Clear All

Click

to map the fields.

The

Edit Field Mapping

dialog box closes.

To revert to the default

Data Integration Hub

table and field mapping, click

Auto Map

in the

Field Mapping

page.

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 Relational Database 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 4. View and Edit Publication Field Mapping

Step 4. View and Edit Publication Field Mapping