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
- Create 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.
Procedure
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.