Fact changes tables
Fact changes tables are used for incremental loads for which _FactLoad.FactLoadType = 3 and _FactLoad.FactChangesTable != NULL. The name of this table is stored in the field _FactLoad.FactLoadChanges.
The name is stored in _FactLoad.FactChangesTable.
This table describes the fact changes table:
| Column | Type | Description |
|---|---|---|
| Names of Columns matching Cube's Dimensions | String(71) | Element names of
the columns' matching dimensions.
|
| DataVersion | BigInteger | Version number of the data. |
General information
DataVersion is selected according to the criteria in the _FactLoad table. The row is selected if _FactLoad.LastLoadedVersion < DataVersion <= NewestVersionToLoad. The element data in the columns is then used as a key to select those rows in the fact table to load. Numeric values are aggregated and the total is written to the cube to the cell whose coordinates matches the element combination selected.