Map

Target Sources (Add Row)

Use this page while:

To access this page:

  1. Click dspMigrate in the Navigation pane.
  2. Click Map in the Context bar.
  3. Click the Targets icon on the Process Area Launch page.
  4. Click the Sources icon for a Target.
  5. Click the Update Row Sources icon for a Source.

Field

Description

Sync from Target Design

Click to sync Map with Target Design, updating tables, fields, Sources and lookup tables.

When Map and Target Design are out of sync, the message Pending Design Changes displays to the right of the page name.

Auto Map

Click to create a copy of the rule mappings for fields that exist in the Target table and the Source database object. The fields in the Target table and the Source database object must match for rule mappings to be created.

SOURCE DATABASE OBJECT

Displays name of the Source table or view, or indicates if the Source is an Update Row Source.

NOTE: When a user sets the Source database object and clicks Save, Map validates that the Source database object exists in the System Type. If the Source database object does not exist:

If the user imported a System Type in Target Design for the Target Source, the Source database object is imported into the System Type.

If the user did not import a System Type in Target Design (i.e., an Excel file import, database table import, or manual entry was used for the Target Design), Map displays an error message that the user must set a System Type before field mapping can be performed. Add a System Type to a Target in Target Design (Design > Targets >Vertical View for a Target > System Type ID).

ACTIVE

If checked, the Source is active for the Wave.

Secondary Source

Click to open the Target Sources (Update Row) page to add an Update Row Source to the selected Add Row Source.

Add an Update Row when data from another Source table is needed to update the Add Row Source.

Refer to Add Update Row Sources that are Views and Add Update Row Sources that are Tables  for more information.

Mappings

Click to open the Field Mappings page to create and reset field mappings for all fields in the selected Add Row Source, to view the history for a selected mapping, or to view mapping details. A number does not display on this icon if no field mappings have been activated for the current context.