Targets H
Use this page to:
To access this page:
- Select dspMigrate in the Navigation pane.
- Select Design in the Context bar.
- Click the Targetsicon on the Design page.
Targets V
Use this page to Set the Field Formats for Date, Time, and Decimal For Use in Data Services AutoGen.
Field
Description
Basic
Object Id
Displays the Object to which the Target is assigned. Objects can have multiple Targets assigned. Objects are added in Console and assigned to a Wave-Process Area to create a context.
A Target design is imported into the Object selected on the Target Object Import page (Design > Target Import).
A user can also select an Object when adding the Target manually.
Priority
Displays the display order of the Target on the Targets page.
When a Wave-Process Area uses the Object, the Object priority cascades down to Target Design. Once the Target that belongs to the Object is synced with Map, the priority is also available in Map and displays on the Objects page (Process Area Launch > Objects). The Priority field in Transform is not updated. To change the order the Object is processed, the Priority field can be updated manually in Transform on the Targets page (Process Area Launch > Targets).
Name
Displays the Target name, which is the table name with tt appended to the front.
Description
Displays a brief description of the Target table.
Usage
Displays how fields in the Target are used.
Values are:
- Natural – The fields exist in the Target system. The system adds a “z” to the front of the field name used in the Source table.
- Utility – The fields do not exist in the Target system, but can be used to register rules and reports to in Transform. Fields of this type should be captured in Target Design. A utility field is added to the Target table to be used by the AutoGen process. Utility fields will be appended to BOTH the Target and Source table as is. No “z” field will be appended.
NOTE: A visibility can be set so that Utility fields can be mapped. Refer to Set Visibility for Mapping of Target and Source Fields for more information.
NOTE: By default, the visibility of a Utility field is set to NONE, with the exception of zLegacy keys. zLegacy key fields will default to Source visibility. Refer to Set Visibility for Appended Utility Columns for more information.
Target System Table Name
Displays the name of the table in the Target system, which is the name in the NAME field without the tt appended to the front.
System Type ID
Displays the System Type that was imported to create the Target design, or the System Type that was selected for the Target.
Refer to Import a Target Design from a System Type and System Types for more information.
Details
Comments
Displays a user-entered comment about the Target.
This field is for documentation purposes only.
Instructions
Displays instructions about how to use the Target in mapping or other functions.
This field is for documentation purposes only.
Documentation
Click Upload a file to upload documentation related to the Target field. If documentation has been uploaded, the Download a File icon is active, and the file can be downloaded. The Download a File icon is disabled if no documentation has been uploaded for the Target.
Dependencies
Parent Targets
Click to open the Target Dependency (Parents) page to view a list of Target tables that have a parent dependency with the selected Target (i.e., the selected Target is a child of the Targets that display on this page).
The number on the icon represents the number of Targets that have a parent dependency with the selected Target.
Refer to Set Target Dependencies for more information.
Child Targets
Click to open the Target Dependency (Children) page to view a list of Target tables that have a child dependency with the selected Target (i.e., the selected Target is a parent of the Targets that display on this page).
The number on the icon represents the number of Targets that have a child dependency with the selected Target.
Refer to Set Target Dependencies for more information.
Field Formats
Date Format
Displays the format to use for date fields when writing validation rules in Data Services AutoGen.
The Date Format works in conjunction with the Field Format field on the Target Fields page’s Vertical View, where the type of format for data fields is stored.
For example, the Date Format for a Target is set in this field at YYYYDDMM.
A user selects Date in the Field Format list box on the Target Fields Vertical View for the field Received By Date.
The data in the Received By Date field passes through the migration process with a data type of NVARCHAR. When validation rules are written for this field in Date Services AutoGen, the format of the data in the Received By Date field is formatted as YYYYDDMM so that it can be loaded into the Target with no errors.
Refer to Set the Date, Time, and Decimal Formats for more information.
Time Format
Displays the format to use for time fields when writing validation rules in Data Services AutoGen.
The Time Format works in conjunction with the Field Format field on the Target Fields page’s Vertical View, where the type of format for data fields is stored.
For example, the Time Format for a Target is set in this field as HH:MM:SS.
A user selects Time in the Field Format list box on the Target Fields Vertical View for the field Received By Time.
The data in the Received By Time field passes through the migration process with a data type of NVARCHAR. When validation rules are written for this field in Date Services AutoGen, the format of the Received By Time field is set as HH:MM:SS so that it can be loaded into the Target with no errors.
Refer to Set the Field Formats for Date, Time, and Decimal For Use in Data Services AutoGen for more information.
Decimal Format
Displays the separator format (either “,” or “.") to use for decimal fields when writing validation rules in Data Services AutoGen.
The Decimal Format works in conjunction with the Field Format on the Target Fields page’s Vertical View, where the type of format for data fields is stored.
Refer to Set the Field Formats for Date, Time, and Decimal For Use in Data Services AutoGen for more information.
Advanced
Target Table Join
Click to open the Target Table Join page to view or enter information about joins in Target tables for the selected Target. This information is for documentation purposes only.
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.