Transformation
Overview
Transformation is a schema type that contains transformation objects and their generated outputs.
Function
Use this type when data must be combined, calculated, filtered, or reshaped between staging and core or data mart layers. Selecting it supports transformation-oriented objects.
When to use
Choose Transformation when data must be combined, calculated, filtered, or reshaped between staging and core or data mart layers.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Create the schema in the appropriate layer and assign the Transformation type. |
| Processing | Transformations in the schema generate intermediate or reusable data logic. |
| Output | The schema contains transformation views, related tables, or intermediate structures. |
Type-specific properties
| Property | Description |
|---|---|
| Layer | Warehouse layer containing the schema. |
| Transformations | Transformation definitions owned by the schema. |
| Generated views or tables | Objects produced from transformation logic. |
| References | Relationships used by transformations. |
Compatibility and limitations
The schema's outputs should have clear ownership and dependency rules.
Relationships
| Related entity | Relationship |
|---|---|
| Schema | The schema type identifies the architectural role of the schema entity. |
| Layer | Schemas belong to layers that organize warehouse processing. |
| Table and transformation | Tables and transformations are created inside schemas according to their intended role. |
