Target

Overview

Target defines a destination object for data mapping from a Source. It is the central part of DIH where the mapping expressions are captured.

Target structure’s three levels.

  • Target — Identifies the destination table or service for the mapping
  • Target Mapping — Identifies the source, predicate conditions and transformations
  • Target Mapping Detail — Maps source fields to target fields

View

FieldDescription
Target Type

Specifies the types of conversion that the executable supports and which types of targets it can process. The following are the possible values:

  • TableSet — Uses set-based SQL statements for inserts.
  • TableCursor — Uses row-by-row insert statements.
  • Service — Calls an API service to populate the target.

Mandatory: Yes

Target IdName of the target.

Mandatory: Yes
Table Id

If you select TableSet or TableCursoryou need to supply the following:

Unique Oracle object to identify the table.

DescriptionDescription of the target.

Mandatory: Yes
ServiceIf you select Service, you need to supply the service name.

Name of the service.
Mappings > SequenceSpecifies the order of the mapping process.
Mappings > SourceParameters used for mapping. For more information, see Source configurations.
Mappings > DetailsIndicates the field-level mapping expressions.

Source Configurations

FieldDescription
Source IdDefines the input for the mapping sequence. It must be an Id of an existing Source.
TransformerDefines an existing transformer Java class.
Character Data Format

Only applicable to target type: Service.

Specifies the format for string-based data. The following are the possible values:

  • XML
  • JSON
HTTP Method

Only applicable to target type: Service.

Type of request. The following are the possible values:

  • POST
  • PUT
  • GET
  • DELETE
Url Path

Only applicable to target type: Service.


Endpoint of the API-based targets.

PredicateFilters the source data using a where clause. The predicate can also refer to any columns exposed by the source.
CommentsAdditional notes for mapping.

Other details

Click the icon to view the Created By and Last Modified By details of the selected target.

Filter

The Target module allows you to search for a target by entering a partial or full Target Id in the Filter textbox.

Add a target

To create a target, follow these steps:

  1. Click Create New.

  2. Select a Target Type in the dropdown list.

  3. Enter a valid Oracle object name in the Target Id field.

  4. Select a Table Id from the dropdown list. (Required for TableSetand TableCursortarget types)

  5. Enter the description in the Description field.

  6. Select Service from the dropdown list. (Required for Servicetarget type)

  7. Click Add button to create the mapping sequence.

  8. Enter valid values in the following fields:

    • Source Id
    • Transformer
    • Character Date Format
    • HTTP Method
    • Url Path
    • Predicate
    • Comments

  9. Click details to define the field-level mappings.

  10. The details will populate the fields. Click the Add button to add new rows.

  11. Click Save to save the new target.

Modify a target

The Target module allows you to update the details of an existing target. To make modifications, select the target from the list and change the values in the fields as needed.

Clone a target

The Target module enables you to clone an existing target. When you clone a target, all metadata is duplicated except the Target Id. To clone a target, follow these steps:

  1. Click the icon.

  2. Click Clone.

  3. Enter a valid and unique target id.

  4. Click Okay.

Delete a target

To delete a target, click the and select Delete.

When deleting a target, ensure that you are deleting the correct target because it will be permanently removed from the system.

Roles

The Target module includes the icon, which lets you view or modify the roles assigned to the selected target.

Add a target role

To add a new role, follow these steps:

  1. Click Create New.

  2. Select the role from the Role ID dropdown list. The newly added role IDs are highlighted in green.

  3. Click Save. Once saved, the green highlight from the previous step will disappear.

Delete a target role

To delete a role, follow these steps:

  1. Click of the role id you wish to delete.

  2. Click Save. Once saved, the role in the red highlight will be deleted.