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.
Manage dependencies for a Script transformation
Review a Script transformation’s input and output references, dependency detection, assigned package, and package prerequisites.
Manage dependencies for an External transformation
Confirm an External transformation’s assigned package and maintain that package’s manual prerequisites.
How to create a union transformation
Combine compatible table or transformation inputs in a Union transformation, then review column alignment and the generated statement.
Using calendar macro in transformation
Enter a calendar macro call for a compatible transformation column, save the definition, and inspect the resulting SQL.
