A constant transformation allows you to apply a constant value to define an attribute
of a logical entity or one of the parameters of a function transformation.
-
On the Create Mapping <logical model name> page,
select the entity corresponding to the attribute to which you want the
transformed value applied, and click the Transformations
collapsible tab on the right side of the page.
The
Transformations panel is displayed showing
the name of all the attributes in the selected entity. The
Transformation column remains blank initially. It
displays the transformation type after you save the transformation.
Note: The Transformation panel doesn't
display details of the physical model table. In case you click a physical
model table after an entity and open the
Transformation panel, it displays details of the
last selected entity.
-
Select the attribute to which you want the transformed value applied, and click
the Transformation icon .
The Transformation of column '<column name>'
pop-up window is displayed.
-
Select the Constant option, and from the
Type drop-down list, select the data type of the
constant value you want to define.
-
In the Value field, enter a constant value for the
selected data type.
-
Click OK.
The applied constant transformation is reflected on the canvas with a transformation
node and it is indicated as Constant
transformation in the Transformation panel.Note: The
Transformation of column '<column name>' pop-up window
is displayed when you double-click this node.