Applying a Conversion Transformation
Note: These steps do not apply to the conversion functions
to_bytes
and to_chars
.The mapping is saved and the mapping icon changes from read to green for this logical model in the Models tab of the Modeling page.
Example - Applying a Cast Conversion Function Transformation
For example: To convert an integer value fromBALANCE
column of the
CUSTOMER
table of ClientSheet
physical model into
a float value to populate the CUSTBALANCE
column of a
CUSTPROFILE
logical entity: - Select the
CUSTPROFILE
entity on the canvas. - Click the Transformations panel and in the panel, click
the Transformation icon against the
CUSTBALANCE
column. - In the popup, select the Function option.
- In the Category field, select Conversion.
- In the Name field, select the cast(Integer value,string target) function. You get option to set the value and target below the entry fields.
- Click Value, and select the Column
option.
- In the physical model Name drop-down, select the
physical model
ClientSheet
. - In the Table Name drop-down, select a table
CUSTOMER
. - In the Column Name drop-down, select the column
BALANCE
.
- In the physical model Name drop-down, select the
physical model
- Click Target and do these selections. Note: The expected target data type is string in this example.
- Select the Constant option.
- From the Type drop-down, select the datatype
String
. - In the Value field, enter Float. This is the target datatype.
- Click OK.
The applied cast conversion function transformation is depicted on the canvas.