TransDimension Table
The TransDimension table in the transactions database contains information about which columns in the transactions database should be transferred to which members in the Data Warehouse.
The following table describes the columns in the TransDimension table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
DimensionName |
nvarchar(100) |
no |
The name of the member in the Data Warehouse. |
FieldName |
nvarchar(100) |
no |
The name of a column in one of the tables in the transactions database. |
CategoryName |
nvarchar(100) |
no |
The name of the class in the Data Warehouse. |
KeyField |
bit |
no |
Whether the member should be a key in the Data Warehouse. |
RequiredDim |
bit |
no |
Whether the member must have a value in the Data Warehouse. |