Table TRANSACTION_TIME_DIMENSION

DescriptionTransaction Time dimension indicates the different patterns defined for the "WHEN DO THEY SPEND" dimension. For example, Day and Night.

Columns
TRANSACTION_TIME_DIMENSION_IDTRANSACTION_TIME_DIMENSION_ID
DESCRIPTIONDESCRIPTION

Primary Key
TRANSACTION_TIME_DIMENSION_PKTRANSACTION_TIME_DIMENSION_PK

Indexes
TRANSACTION_TIME_DIMENSION_PKTRANSACTION_TIME_DIMENSION_PK

Column Details

 TRANSACTION_TIME_DIMENSION_ID
DescriptionThe unique identifier of the Transaction Time dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates the textual representation of the Time dimension.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 TRANSACTION_TIME_DIMENSION_PK
DescriptionThe unique identifier of the Transaction Time dimension.
MemberTRANSACTION_TIME_DIMENSION_ID [BIGINT]

Index Details

 TRANSACTION_TIME_DIMENSION_PK
DescriptionThe unique identifier of the Transaction Time dimension.
Is Uniquetrue
Is Clusteredfalse
MemberTRANSACTION_TIME_DIMENSION_ID [BIGINT] Ascending