Fact table
The
DEPM_MOD_FACTTABLE table fills a cube with data.| Name | Definition |
|---|---|
| CubeID | nvarchar(50) NOT NULL; PK |
| TableName | nvarchar(50) NOT NULL; PK |
| Order | int NOT NULL; unique key |
Order defines the order in which data fills the cube.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| CubeID | _cube | ID |
| TableName | _table | Name |