Table TRANSACTION_FACT

DescriptionTransaction Fact is a fact table recording the key measures relating to Transactions.

Columns
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
ACCOUNT_ARRANGEMENT_DIMENSION_IDACCOUNT_ARRANGEMENT_DIMENSION_ID
GEOGRAPHIC_AREA_DIMENSION_IDGEOGRAPHIC_AREA_DIMENSION_ID
TRANSACTION_IDTRANSACTION_ID
TRANSACTION_TYPE_DIMENSION_IDTRANSACTION_TYPE_DIMENSION_ID
AMOUNTAMOUNT
TRANSACTION_TIME_DIMENSION_IDTRANSACTION_TIME_DIMENSION_ID
BALANCEBALANCE
CASHFLOW_PATTERN_DIMENSION_IDCASHFLOW_PATTERN_DIMENSION_ID

Foreign Key
TRANSACTION_FACT_CALENDAR_DATE_DIMENSION_FKTRANSACTION_FACT_CALENDAR_DATE_DIMENSION_FK
TRANSACTION_FACT_CHANNEL_DIMENSION_FKTRANSACTION_FACT_CHANNEL_DIMENSION_FK
TRANSACTION_FACT_GEOGRAPHIC_AREA_DIMENSION_FKTRANSACTION_FACT_GEOGRAPHIC_AREA_DIMENSION_FK
TRANSACTION_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FKTRANSACTION_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FK
TRANSACTION_FACT_TRANSACTION_TIME_DIMENSION_FKTRANSACTION_FACT_TRANSACTION_TIME_DIMENSION_FK
TRANSACTION_FACT_TRANSACTION_TYPE_DIMENSION_FKTRANSACTION_FACT_TRANSACTION_TYPE_DIMENSION_FK

Primary Key
TRANSACTION_FACT_PKTRANSACTION_FACT_PK

Indexes
CHANNEL_IDXCHANNEL_IDX
TRANSACTION_FACT_PKTRANSACTION_FACT_PK

Column Details

 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the Calendar Date Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_DIMENSION_ID
DescriptionThe unique identifier of the Channel Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACCOUNT_ARRANGEMENT_DIMENSION_ID
DescriptionThe unique identifier of the Account Arrangement Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_DIMENSION_ID
DescriptionThe unique identifier of the Geographic Area Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_ID
DescriptionThe unique identifier applied to the Transaction.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_TYPE_DIMENSION_ID
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AMOUNT
DescriptionA measure that indicates the transaction amount. Negative amount indicates the debits/expense and Positive amount indicates the credits/income.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_TIME_DIMENSION_ID
DescriptionThe unique identifier of the Transaction Time dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BALANCE
DescriptionA measure that indicates the running account balance of the indiviual customer.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CASHFLOW_PATTERN_DIMENSION_ID
DescriptionThe unique identifier of the cash flow pattern dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 TRANSACTION_FACT_CALENDAR_DATE_DIMENSION_FK
DescriptionThe unique identifier of the Calendate Date dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Parent TableCALENDAR_DATE_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCALENDAR_DATE_DIMENSION_PK



 TRANSACTION_FACT_CHANNEL_DIMENSION_FK
DescriptionThe unique identifier of the channel dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnCHANNEL_DIMENSION_ID [BIGINT]
Parent TableCHANNEL_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCHANNEL_DIMENSION_PK



 TRANSACTION_FACT_GEOGRAPHIC_AREA_DIMENSION_FK
DescriptionThe unique dimension of the geographic area dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_DIMENSION_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA_DIMENSION
Parent Multiplicity0..1
Unique ConstraintGEOGRAPHIC_AREA_DIMENSION_PK



 TRANSACTION_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FK
DescriptionThe unique identifier of the Individual Customer dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK



 TRANSACTION_FACT_TRANSACTION_TIME_DIMENSION_FK
DescriptionThe unique identifier of the transaction time dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnTRANSACTION_TIME_DIMENSION_ID [INTEGER]
Parent TableTRANSACTION_TIME_DIMENSION
Parent Multiplicity0..1
Unique ConstraintTRANSACTION_TIME_DIMENSION_PK



 TRANSACTION_FACT_TRANSACTION_TYPE_DIMENSION_FK
DescriptionThe unique identifier of the Transaction Type dimension.
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnTRANSACTION_TYPE_DIMENSION_ID [BIGINT]
Parent TableTRANSACTION_DIMENSION
Parent Multiplicity0..1
Unique ConstraintTRANSACTION_DIMENSION_PK

Primary Key Details

 TRANSACTION_FACT_PK
DescriptionThe unique identifier of the Transaction Fact.
MemberTRANSACTION_ID [BIGINT]

Index Details

 CHANNEL_IDX
Is Uniquefalse
Is Clusteredfalse



 TRANSACTION_FACT_PK
Is Uniquetrue
Is Clusteredfalse
MemberTRANSACTION_ID [BIGINT] Ascending