Target Sources H
Use this page to:
To access this page:
- Click dspMigrate in the Navigation pane.
- Click Map in the Context bar.
- Click the Targets icon on the Process Area Launch page.
- Click the Sources icon for a Target.
Target Sources V
Use this page to:
- Add ZActive
- Update Unmapped Add Row and Update Row Source Fields to NotUsed
- Add Update Row Sources
- Update Client and Language for all Sources
- Add an Assemble Where Clause
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 the Import Field Mappings page 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.
Reset
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
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.
Source Schema
Source ID
Displays name of the Source database as defined in Target Design.
Source Database Object
Displays name of Source table or view, or indicates if the Source is an Update Row Source.
Source Type
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.
Schema Columns
Click to view a list of Source schema columns used to build the Source table.
System Type Table Fields
Click to display the System Types Tables page to view or update the System Type table & fields.
ST Table Settings
St Object Type
Displays the type of object in the Source: Table or View. Default value is Table.
St Table
Displays the name of the Map-generated table that rules are created against.
Add 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.
Active Field
Displays user-defined value to filter data in a Source table that is loaded into a target table.
z Source
Displays the name of Source where data is being created. This field is set in Target Design.
z Source Override
Displays user-entered Source that overrides the ZSource for the target configured in Target Design.
Assemble Where Clause
Displays the Assemble Where Clause to be added to the CranPort package. The Assemble Where Clause is used 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.
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.
Value Mapping Settings
Client
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.
Language
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.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.