Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Step 6. View and Edit Subscription Field Mapping

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

Field Mapping

page of the subscription wizard.

If you created joins in "Step 4. Define Joins", configure field mapping of joins to target tables and fields.

Perform the following actions to view and edit the mapping of a topic table or a join to a target 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 Target 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 target 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 row of the target table to which the topic table is mapped, in the

Mapped To

column.

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

Map Target Table

The

Edit Table Mapping

dialog box closes. The

Field Mapping

page shows the revised mapping.

Perform the following actions on the

Field Mapping

page to view and to map fields in a topic table to fields in a target 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 or in the target table, enter a string for the field name in the

Find Field

text box, and then click

Choose

Display unmapped fields only

to show only unmapped fields in the search results.

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

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

Topic Table

section to the

Target 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

table and field mapping, click

Auto Map

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 mappings, click

Clear All

in the

Field Mapping

page.

The subscription must contain at least one mapped topic table.

Optionally, select the

Powercenter Target Load Order

to specify the order in which the integration service loads the target tables. By default, this option is disabled.

In the

Field Mapping

page, click

The

Filter

page appears.

Creating an Automatic Relational Database Subscription

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 6. View and Edit Subscription Field Mapping

Step 6. View and Edit Subscription Field Mapping