| BANKING Data Model |
Description | Transaction Time dimension indicates the different patterns defined for the "WHEN DO THEY SPEND" dimension. For example, Day and Night. |
Columns | |
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Transaction Time dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Description indicates the textual representation of the Time dimension. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Description | The unique identifier of the Transaction Time dimension. |
Member | TRANSACTION_TIME_DIMENSION_ID [BIGINT] |
Index Details |
Description | The unique identifier of the Transaction Time dimension. |
Is Unique | true |
Is Clustered | false |
Member | TRANSACTION_TIME_DIMENSION_ID [BIGINT] Ascending |
| BANKING Data Model |