Target Sources H

Description

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.

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 in order for rule mappings to be created.

NOTE: The Auto Map feature sets the Action on the mapping to Copy and the Mapping Status to In Progress.

Displays name of the Source database as defined in Target Design.

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).

If checked, the Source is active for the Wave.

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

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

Refer to Add Update Row Sources for more information.

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

Description

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

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.

Click to open the Import Field Mappings page to review and import all available mappings approved in other Waves to the current Source.

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

Click to reset the Target Source Schema page.

Resetting re-imports any additional fields for this Add Row Source from the System Type.

Basic Details

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.

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

Source Schema

Displays name of the Source database as defined in Target Design.

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

Displays the Source type: Add Row or Update Row. Update Row is used if an Update Row Source is used to update the values. Default value is Update Row. Add Row is used when there are two Source data tables within the same Source.

Click to view a list of Source schema columns used to build the Source table.

Click to display the System Types Tables page to view or update the System Type table & fields.

ST Table Settings

Displays the type of object in the Source: Table or View. Default value is Table.

Displays the name of the Map-generated table that rules are created against.

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.

Displays user-defined value to filter data in a Source table that is loaded into a target table.

Displays the name of Source where data is being created. This field is set in Target Design.

Displays user-entered Source that overrides the ZSource for the target configured in Target Design.

Displays the WHERE clause that is applied to a Target Source, which is then included in the CranPort Package to filter Source data when importing or refreshing a Target. The WHERE clause must consist of a column name, an operator and a value. For example, Country = 'US'.

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.

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.

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

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.

Value Mapping Settings

Displays the name of the field that contains ERP system client information.

This value is entered in Target Design on the Vertical View of the Target Lookup Table page.

Displays the name of the field that contains the ERP system client information.

This value is entered in Target Design on the Vertical View of the Target Lookup Table page.