Transformations
This feature gives you the flexibility of transforming a value before populating it to a column in a logical model entity. The values are sourced from the columns of physical model tables.
On the basis of the functions you need to apply on values before populating the logical model
columns, you can do transformation on:
- Columns: To populate values from a column of a physical model table
- Constant: To apply a constant value to a logical model column or to one of the parameters of a function transformation
- Function: To apply functions of string, numeric, conversion, and datetime to a logical model column, or to one of the parameters of a function transformation.
You can create complex nested transformations within the parent transformation.
Conversion Function Transformation
A conversion function allows you to convert values from one data type into another data type, from one format into another format, or parse values according to desired formats.
A conversion function is applied to convert the data from a source table column data or a constant into the desired data type or format. This converted data populates the selected column of a logical entity.
The various conversion functions available are:
- cast
- This function allows you to convert values of one data type into another data type.
- format
- This function allows you convert a value of any data type into a string value using a provided format.
- parse
- This function allows you to parse a string value into the desired data type using a provided format.
- to_bytes
- This function allows you to convert a CLOB type value into bytes.
- to_chars
- This function allows you to convert a BLOB type value into chars.
Parameters of Conversion Functions
Thecast
,
format
, and parse
conversion functions have two parameters:
- Source value of a certain data type and format
- Target data type or format into which the source value needs to be converted, or using which the source value needs to be parsed.
Note: This convention is not applicable for
to_bytes
and
to_chars
conversion functions.