dbo.DimDate - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimDate
Module	Dimensions

Columns

	Name	Data type
1	DateKey	int
2	FullDateAlternateKey	date
3	DayNumberOfWeek	tinyint
4	EnglishDayNameOfWeek	nvarchar(10)
5	SpanishDayNameOfWeek	nvarchar(10)
6	FrenchDayNameOfWeek	nvarchar(10)
7	DayNumberOfMonth	tinyint
8	DayNumberOfYear	smallint
9	WeekNumberOfYear	tinyint
10	EnglishMonthName	nvarchar(10)
11	SpanishMonthName	nvarchar(10)
12	FrenchMonthName	nvarchar(10)
13	MonthNumberOfYear	tinyint
14	CalendarQuarter	tinyint
15	CalendarYear	smallint
16	CalendarSemester	tinyint
17	FiscalQuarter	tinyint
18	FiscalYear	smallint
19	FiscalSemester	tinyint

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.FactCallCenter	dbo.DimDate	dbo.FactCallCenter.DateKey = dbo.DimDate.DateKey	FK_FactCallCenter_DimDate
dbo.FactCallCenter.DateKey = dbo.DimDate.DateKey Name: FK_FactCallCenter_DimDate
dbo.FactCurrencyRate	dbo.DimDate	dbo.FactCurrencyRate.DateKey = dbo.DimDate.DateKey	FK_FactCurrencyRate_DimDate
dbo.FactCurrencyRate.DateKey = dbo.DimDate.DateKey Name: FK_FactCurrencyRate_DimDate
dbo.FactFinance	dbo.DimDate	dbo.FactFinance.DateKey = dbo.DimDate.DateKey	FK_FactFinance_DimDate
dbo.FactFinance.DateKey = dbo.DimDate.DateKey Name: FK_FactFinance_DimDate
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.OrderDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate
dbo.FactInternetSales.OrderDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.DueDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate1
dbo.FactInternetSales.DueDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate1
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.ShipDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate2
dbo.FactInternetSales.ShipDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate2
dbo.FactProductInventory	dbo.DimDate	dbo.FactProductInventory.DateKey = dbo.DimDate.DateKey	FK_FactProductInventory_DimDate
dbo.FactProductInventory.DateKey = dbo.DimDate.DateKey Name: FK_FactProductInventory_DimDate
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.OrderDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate
dbo.FactResellerSales.OrderDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.DueDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate1
dbo.FactResellerSales.DueDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate1
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.ShipDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate2
dbo.FactResellerSales.ShipDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate2
dbo.FactSalesQuota	dbo.DimDate	dbo.FactSalesQuota.DateKey = dbo.DimDate.DateKey	FK_FactSalesQuota_DimDate
dbo.FactSalesQuota.DateKey = dbo.DimDate.DateKey Name: FK_FactSalesQuota_DimDate
dbo.FactSurveyResponse	dbo.DimDate	dbo.FactSurveyResponse.DateKey = dbo.DimDate.DateKey	FK_FactSurveyResponse_DateKey
dbo.FactSurveyResponse.DateKey = dbo.DimDate.DateKey Name: FK_FactSurveyResponse_DateKey

Unique keys

	Key name	Columns	Description
	PK_DimDate_DateKey	DateKey
	AK_DimDate_FullDateAlternateKey	FullDateAlternateKey

Used by

Name
dbo.DimDate
dbo.vDMPrep
dbo.vAssocSeqLineItems
dbo.vAssocSeqOrders
dbo.vTargetMail
dbo.vTimeSeries
dbo.FactCallCenter
dbo.FactCurrencyRate
dbo.FactFinance
dbo.FactInternetSales
dbo.FactInternetSales
dbo.FactInternetSales
dbo.FactProductInventory
dbo.FactResellerSales
dbo.FactResellerSales
dbo.FactResellerSales
dbo.FactSalesQuota
dbo.FactSurveyResponse

Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58