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.