Defining a constant value on a mapping group

If you want to insert a fixed value that is not being derived from the source side of the mapping, then you define a constant value. You can add a constant value to any element of your target schema. The assignment of a constant value to an element must be contained in a particular mapping group.
Prerequisite:
  • Creating a mapping model
  • Create mappings between a source and a target, or run the discover function and accept at least one mapping.

Constant values can only be added to fields that are included in the mapping group. You can define a constant value on one of the target columns in the mapping group by using one of the functions of the Expression Builder.

To define a constant value on a mapping group:

  1. From the mapping pane select the Mapping Groups view.
  2. Select the mapping group to which you want to add a constant value.
  3. Select the Mapping Group Details view.
  4. Right-click on a target column that is part of the Mapping Group. Select Create Constant Mapping from the menu.
  5. In the Expression Builder window, double-click a function from the Functions field to move the function to the Constant Value field. You can also type the constant value in the expression field, or specify functions in this field.
  6. Complete the empty function that is provided with a constant that you want to apply to the target column. You can also add a constant to the target column by typing directly into the Constant Value field.

Feedback