Summary of Recommended Workflow
| Step |
Action |
Description |
| 1 |
Create Connector |
Define source system and metadata |
| 2 |
Define References |
Manually or automatically detect relationships |
| 3 |
Import Tables |
Load source tables into staging |
| 4 |
Historize Data |
Add historization for time-based tracking |
| 5 |
Build Transformations |
Create dimensions and facts |
| 6 |
Add Calendar Dimension |
Generate time intelligence |
| 7 |
Create Data Mart |
Build the star schema |
| 8 |
Generate Surrogate Keys |
Optimize joins |
| 9 |
Define Metrics |
Add measures and calculations |
| 10 |
Deploy |
Generate and synchronize the data warehouse |
