Transformations
Define transformation logic and configure how its results are used in the warehouse. The guides cover Regular and Manual transformations, expressions, dimensions, snapshots, and datamart assignments.
Choose a creation guide for a new Transformation, or a focused guide when changing a rule, expression, history setting, or analytical assignment. Review the saved definition before downstream use.
Build and configure Transformations
Create and save a Regular transformation
Create a Regular transformation, configure its inputs and output definitions, and check the saved result.
Create and save a Manual transformation
Create a Manual transformation, maintain its statement and output configuration, and verify the saved definition.
Create a Macro and use it in a Transformation statement
Define a Macro and call it from a Transformation statement with the required arguments.
Create a calendar dimension
Set the calendar name, date range, and related settings, then create and verify the calendar dimension.
Choose a Transformation historization type and assign snapshots
Choose the required Transformation history behavior, assign existing snapshots or groups, and verify the saved settings.
Apply a Predefined transformation rule
Select and apply a Predefined transformation rule, then review its effect on the Transformation configuration.
Assign an existing Transformation to a datamart star
Assign an existing Transformation to the intended datamart star and check its analytical role.
