A column transformation allows you to link the required column of a physical model
table to define an attribute of a logical entity or one of the parameters of a function
transformation. You can do a column transformation by using the
Transformations panel as described below or by linking a
physical model column with an attribute in a logical entity directly on the
canvas.
-
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 Column option, and from the
Physical Model Name drop-down list, select the
required physical model.
-
From the Table Name drop-down list, select the required
table.
-
From the Column Name drop-down list, select the required
column that you want to map with the attribute.
-
Click OK.
The selected column gets mapped with the attribute and it is indicated
by a connecting arrow between the two on the canvas. The
Transformation panel displays this as a
Simple transformation.
Note: The data type of the
attribute is inherited from the mapped physical model column.