Using Database Function Sets
Database function sets contain a list of functions and operators that can be used for building transformations. These function sets may be created, edited, deleted, imported and exported using the Database Functions options from the Tools menu.
Column Transformation Properties
A drop-down list enables you to select which set of functions are to be displayed in the tree view when creating a transformation on a column of a table.
Transformation Definition
A drop-down list enables you to select which set of functions are to be displayed in the tree view when creating a re-usable transformation using Tools > Define Re-Usable Transformations.
Connection Properties
If the Data Warehouse Metadata Connection Indicator check-box is selected In the connection Properties window, a drop-down list Default Transform Function Set is displayed. This is the default set selected in the transformation screens above.
