Dimension.City - WideWorldImportersDW

City dimension

Columns

		Name	Data type	Attributes	Description
	1	City Key	int	Default: NEXT VALUE FOR [Sequences].[CityKey]	DW key for the city dimension
DW key for the city dimension Default: NEXT VALUE FOR [Sequences].[CityKey]
	2	WWI City ID	int		Numeric ID used for reference to a city within the WWI database
Numeric ID used for reference to a city within the WWI database
	3	City	nvarchar(50)		Formal name of the city
Formal name of the city
	4	State Province	nvarchar(50)		State or province for this city
State or province for this city
	5	Country	nvarchar(60)		Country name
Country name
	6	Continent	nvarchar(30)		Continent that this city is on
Continent that this city is on
	7	Sales Territory	nvarchar(50)		Sales territory for this StateProvince
Sales territory for this StateProvince
	8	Region	nvarchar(30)		Name of the region
Name of the region
	9	Subregion	nvarchar(30)		Name of the subregion
Name of the subregion
	10	Location	geography		Geographic location of the city
Geographic location of the city
	11	Latest Recorded Population	bigint		Latest available population for the City
Latest available population for the City
	12	Valid From	datetime2(7)		Valid from this date and time
Valid from this date and time
	13	Valid To	datetime2(7)		Valid until this date and time
Valid until this date and time
	14	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.City	Fact.Order.City Key = Dimension.City.City Key	FK_Fact_Order_City_Key_Dimension_City Foreign key constraint referencing City.City Key
Fact.Order.City Key = Dimension.City.City Key Name: FK_Fact_Order_City_Key_Dimension_City Foreign key constraint referencing City.City Key
Fact.Sale	Dimension.City	Fact.Sale.City Key = Dimension.City.City Key	FK_Fact_Sale_City_Key_Dimension_City Foreign key constraint referencing City.City Key
Fact.Sale.City Key = Dimension.City.City Key Name: FK_Fact_Sale_City_Key_Dimension_City Foreign key constraint referencing City.City Key

Unique keys

	Key name	Columns	Description
	PK_Dimension_City	City Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

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