Dimension.Customer - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Customer
Modules	Movement, Order, Sale, Transaction

Customer dimension

Columns

		Name	Data type	Attributes	Description
	1	Customer Key	int	Default: NEXT VALUE FOR [Sequences].[CustomerKey]	DW key for the customer dimension
DW key for the customer dimension Default: NEXT VALUE FOR [Sequences].[CustomerKey]
	2	WWI Customer ID	int		Numeric ID used for reference to a customer within the WWI database
Numeric ID used for reference to a customer within the WWI database
	3	Customer	nvarchar(100)		Customer's full name (usually a trading name)
Customer's full name (usually a trading name)
	4	Bill To Customer	nvarchar(100)		Bill to customer's full name
Bill to customer's full name
	5	Category	nvarchar(50)		Customer's category
Customer's category
	6	Buying Group	nvarchar(50)		Customer's buying group
Customer's buying group
	7	Primary Contact	nvarchar(50)		Primary contact
Primary contact
	8	Postal Code	nvarchar(10)		Delivery postal code for the customer
Delivery postal code for the customer
	9	Valid From	datetime2(7)		Valid from this date and time
Valid from this date and time
	10	Valid To	datetime2(7)		Valid until this date and time
Valid until this date and time
	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.Order	Dimension.Customer	Fact.Order.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Order_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Order.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Order_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Sale	Dimension.Customer	Fact.Sale.Bill To Customer Key = Dimension.Customer.Customer Key	FK_Fact_Sale_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Sale.Bill To Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Sale_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Sale	Dimension.Customer	Fact.Sale.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Sale_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Sale.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Sale_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction	Dimension.Customer	Fact.Transaction.Bill To Customer Key = Dimension.Customer.Customer Key	FK_Fact_Transaction_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction.Bill To Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Transaction_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction	Dimension.Customer	Fact.Transaction.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Transaction_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Transaction_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key

Unique keys

	Key name	Columns	Description
	PK_Dimension_Customer	Customer Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

Name
Dimension.Customer
Fact.Movement
Fact.Order
Fact.Sale
Fact.Sale
Fact.Transaction
Fact.Transaction

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