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.
Before you begin
Prerequisite:- Creating a mapping model
- Create mappings between a source and a target, or run the discover function
and accept at least one mapping.
About this task
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:
- From the mapping pane select the Mapping Groups view.
- Select the mapping group to which you want to add a constant value.
- Select the Mapping Group Details view.
- Right-click on a target column that is part of the Mapping Group.
Select Create Constant Mapping from the menu.
- 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.
- 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.