Dimension.Employee - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Employee
Modules	Order, Sale

Employee dimension

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		Employee Key	int		Default: NEXT VALUE FOR [Sequences].[EmployeeKey]		DW key for the employee dimension
DW key for the employee dimension Default: NEXT VALUE FOR [Sequences].[EmployeeKey]
	2		WWI Employee ID	int				Numeric ID (PersonID) in the WWI database
Numeric ID (PersonID) in the WWI database
	3		Employee	nvarchar(50)				Full name for this person
Full name for this person
	4		Preferred Name	nvarchar(50)				Name that this person prefers to be called
Name that this person prefers to be called
	5		Is Salesperson	bit				Is this person a staff salesperson?
Is this person a staff salesperson?
	6		Photo	varbinary(MAX)				Photo of this person
Photo of this person
	7		Valid From	datetime2(7)				Valid from this date and time
Valid from this date and time
	8		Valid To	datetime2(7)				Valid until this date and time
Valid until this date and time
	9		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.Order		Dimension.Employee	Fact.Order.Picker Key = Dimension.Employee.Employee Key	FK_Fact_Order_Picker_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order.Picker Key = Dimension.Employee.Employee Key Name: FK_Fact_Order_Picker_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order		Dimension.Employee	Fact.Order.Salesperson Key = Dimension.Employee.Employee Key	FK_Fact_Order_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order.Salesperson Key = Dimension.Employee.Employee Key Name: FK_Fact_Order_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Sale		Dimension.Employee	Fact.Sale.Salesperson Key = Dimension.Employee.Employee Key	FK_Fact_Sale_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Sale.Salesperson Key = Dimension.Employee.Employee Key Name: FK_Fact_Sale_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key

Unique keys

	Key name	Columns	Description
	PK_Dimension_Employee	Employee Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

Name
Dimension.Employee
Fact.Order
Fact.Order
Fact.Sale

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