Table TRANSACTION_FACT

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

Columns
TRANSACTION_IDTRANSACTION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CUSTOMER_SEGMENT_MINI_DIMENSION_IDCUSTOMER_SEGMENT_MINI_DIMENSION_ID
TRANSACTION_DIMENSION_IDTRANSACTION_DIMENSION_ID
NET_CASH_FLOW_AMOUNTNET_CASH_FLOW_AMOUNT
TRANSACTION_SOURCE_SYSTEM_CODETRANSACTION_SOURCE_SYSTEM_CODE

Foreign Key
TRAN_CALENDAR_D_FKTRAN_CALENDAR_D_FK
TRAN_INDIVIDUAL_FKTRAN_INDIVIDUAL_FK
TRAN_TRANSACTI_FKTRAN_TRANSACTI_FK

Primary Key
TRANSACTION_FACT_PKTRANSACTION_FACT_PK

Indexes
TRANSACTION_FACT_PKTRANSACTION_FACT_PK

Column Details

 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



 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
DescriptionIdentifies the Channel Dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
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



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



 TRANSACTION_DIMENSION_ID
DescriptionThe unique identifier of the Transaction Dimension
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NET_CASH_FLOW_AMOUNT
DescriptionThe net cash inflow to, or outflow from, the primary Arrangement affected by the Transaction, resulting from the Transaction. Note that there may be more than one cash flow involved in the Transaction. If the cash flows are all in the same direction, then this is the total of all the flows. If the flows are in opposing directions, then this is the net value of all the flows.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_SOURCE_SYSTEM_CODE
DescriptionThis is the identifier of the source system id of the incoming transaction
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 TRAN_CALENDAR_D_FK
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



 TRAN_INDIVIDUAL_FK
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



 TRAN_TRANSACTI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteCASCADE
Is Identifying Relationshipfalse
Child TableTRANSACTION_FACT
Child Multiplicity*
Key ColumnTRANSACTION_DIMENSION_ID [INTEGER]
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

 TRANSACTION_FACT_PK
DescriptionThe unique identifier of the Transaction Fact
Is Uniquetrue
Is Clusteredfalse
MemberTRANSACTION_ID [BIGINT] Ascending