| WEALTH Data Model |
Description | Transaction Fact is a fact table recording the key measures relating to Transactions. |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier applied to the Transaction. |
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 | The unique identifier of the Calendar Date Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Channel Dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Customer Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Customer Segment Mini Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Transaction Dimension |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The 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 Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This is the identifier of the source system id of the incoming transaction |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CALENDAR_DATE_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | CASCADE |
Is Identifying Relationship | false |
Child Table | TRANSACTION_FACT |
Child Multiplicity | * |
Key Column | TRANSACTION_DIMENSION_ID [INTEGER] |
Parent Table | TRANSACTION_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | TRANSACTION_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Transaction Fact |
Member | TRANSACTION_ID [BIGINT] |
Index Details |
Description | The unique identifier of the Transaction Fact |
Is Unique | true |
Is Clustered | false |
Member | TRANSACTION_ID [BIGINT] Ascending |
| WEALTH Data Model |