Fact.Movement - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Fact
Name	Movement
Module	Movement

Movement fact table (movements of stock items)

Columns

		Name	Data type	Attributes	References	Description
	1	Movement Key	bigint	Identity		DW key for a row in the Movement fact
DW key for a row in the Movement fact Identity
	2	Date Key	date		Dimension.Date	Transaction date
Transaction date References: Dimension.Date
	3	Stock Item Key	int		Dimension.Stock Item	Stock item for this purchase order
Stock item for this purchase order References: Dimension.Stock Item
	4	Customer Key	int		Dimension.Customer	Customer (if applicable)
Customer (if applicable) References: Dimension.Customer
	5	Supplier Key	int		Dimension.Supplier	Supplier (if applicable)
Supplier (if applicable) References: Dimension.Supplier
	6	Transaction Type Key	int		Dimension.Transaction Type	Type of transaction
Type of transaction References: Dimension.Transaction Type
	7	WWI Stock Item Transaction ID	int			Stock item transaction ID in source system
Stock item transaction ID in source system
	8	WWI Invoice ID	int			Invoice ID in source system
Invoice ID in source system
	9	WWI Purchase Order ID	int			Purchase order ID in source system
Purchase order ID in source system
	10	Quantity	int			Quantity of stock movement (positive is incoming stock, negative is outgoing)
Quantity of stock movement (positive is incoming stock, negative is outgoing)
	11	Lineage Key	int			Lineage Key for the data load for this row
Lineage Key for the data load for this row

Relations

Foreign table	Primary table	Join	Title / Name / Description
Fact.Movement	Dimension.Customer	Fact.Movement.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Movement_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Movement.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Movement_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Movement	Dimension.Date	Fact.Movement.Date Key = Dimension.Date.Date	FK_Fact_Movement_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Movement.Date Key = Dimension.Date.Date Name: FK_Fact_Movement_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Movement	Dimension.Stock Item	Fact.Movement.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Movement_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Movement.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Movement_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Movement	Dimension.Supplier	Fact.Movement.Supplier Key = Dimension.Supplier.Supplier Key	FK_Fact_Movement_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Movement.Supplier Key = Dimension.Supplier.Supplier Key Name: FK_Fact_Movement_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Movement	Dimension.Transaction Type	Fact.Movement.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key	FK_Fact_Movement_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key
Fact.Movement.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key Name: FK_Fact_Movement_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key

Unique keys

	Key name	Columns	Description
	PK_Fact_Movement	Movement Key, Date Key	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

Name
Fact.Movement
Dimension.Customer
Dimension.Date
Dimension.Stock Item
Dimension.Supplier
Dimension.Transaction Type

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59