Targets H

Targets V

Use this page to:

To access this page:

  1. Select dspMigrate in the Navigation pane.
  2. Select Design in the Context bar.
  3. Click the Targetsicon on the Design page.

 

Targets V

Targets H

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.