Map

Target Sources (Update Row) H

Target Sources (Update Row) V

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

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 ID

Displays the source name.

SOURCE DATABASE OBJECT

Displays the name of the Source table or view, and the description in the format TABLE (DESCRIPTION).

NOTE: In order for the description to display with the table name, it must be defined in the System Type assigned to the Data Source in Common. If a description is not defined, the Source ID displays with the table name.

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 (as in, 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.

Mappings

Click to open the Field Mappings page to create and reset field mappings for all fields in the selected Update 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.

Relationships

Click to open the Relationship Joins page to add relationship joins for Add Row and Update Row source tables.

When a Target is synced with Target Design, relationships are loaded for the Target based on the dependencies set in Target Design.

For example, the MARC table has a parent relationship with the MARD table (as in, MARD is a child of MARC).

The key fields used in the relationship between the tables are MATNR and WERKS.

A user can build a relationship between the two tables, but the relationship join is only entered for the MARD table.

The MARA table is a parent of the MARC, MAKT, and MARM tables. The key field for the relationship join in these cases is the MATNR field.

Relationships must be built at the child table level (as in, MARC, MAKT, and MARM).

 

Target Sources (Update Row) V

Target Sources (Update Row) H

Field

Description

Copy To

Click to open the Target Source Copy To page to copy source mappings from the current Target Source to another Target Source combination.

Export Field Mappings

Click to export all field mappings with a MAPPING STATUS and a RULE STATUS of Complete on the Field Mappings page to the Common System Tables to be imported into Waves and other Process Areas.

Import Field Mappings

Click to open theImport Field Mappingspage to review and import all available mappings approved in other Waves to the current source.

Auto Update Not Used

Click to set all blank Actions to “NotUsed” for the Target Source mappings.

Basic Details

Mapping Required

If checked, the Update Row source must be mapped.

Track Changes

If checked, workflow notifications are sent to users who are set up to receive mapping changes. Refer to Set up User Notifications for more information.

Comment

Displays a brief, user-defined comment about the source.

Relationships

Click to open the Relationship Joins page to add relationship joins for Add Row and Update Row source tables.

When a Target is synced with Target Design, relationships are loaded for the Target based on the dependencies set in Target Design.

For example, the MARC table has a parent relationship with the MARD table (as in, MARD is a child of MARC).

The key fields used in the relationship between the tables are MATNR and WERKS.

A user can build a relationship between the two tables, but the relationship join is only entered for the MARD table.

The MARA table is a parent of the MARC, MAKT, and MARM tables. The key field for the relationship join in these cases is the MATNR field.

Relationships must be built at the child table level (as in, MARC, MAKT, and MARM).

Source Schema

Source ID

Displays the name of the source.

Source Database Object

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

Schema Columns

Click to open the Target Source Schema page to reset Target Source schema field lengths. If a source was added in Target Design during a System Type import, and the System Type tables for a source contained an invalid length for a column, use the Reset functionality to update a source table with the column’s correct length.

System Type Table Fields

Click to open the System Types Tables Fields page to view the fields in the source table.

ST Table Settings

ST Object Type

Displays table or view.

A view in the Transform database contains the rule that processes against the data in the source database.

A table allows a user to pull data from the same source database that the rule processes against, but to convert the data before it is processed in a rule for the Target Source table. Using mappings, SQL AutoGen can create these pre-processing rules that are run prior to the main source rules.

Update Row Source

Displays the name of the source table for the update row source.

Add Row Source

Displays the name of the Add Row source added in Map and populated by the system. This field must be populated for SQL AutoGen to generate rules

NOTE: If the Add Row source has an Add Row Source Override field entered on the Vertical View of the Target Sources page, then the Update Row source’s Update Row Source Override field on this page must match the Add Row Source Override field.

Update Row Source Override

Displays the user-selected table name that overrides the St Table in the Add Row source, which is used to download data from another table or view.

NOTE: If the Add Row source has an Add Row Source Override field entered on the Vertical View of the Target Sources page, then the Update Row source’s Update Row Source Override field on this page must match the Add Row Source Override field.

Table Details

NOTE: This label and the icons below it do not display if a source database object has not been set. This is set on the Horizontal View of the Target Source (Add Row) or Target Sources (Update Row) page.

Profile

Click to profile the source data source which gathers information about the tables and fields such as record counts, unique values, or field data types.

View Data

Click to open the Target Sources page to view the source data.

View Fields

Click to open the Table Field (Results) page to view profile results such as field data type, length, the percentage of fields that do not have data, and the percentage of fields that have unique values.