dbo.DimCurrency - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimCurrency
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		CurrencyKey	int		Identity
Identity
	2		CurrencyAlternateKey	nchar(3)
	3		CurrencyName	nvarchar(50)

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.DimOrganization		dbo.DimCurrency	dbo.DimOrganization.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_DimOrganization_DimCurrency
dbo.DimOrganization.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_DimOrganization_DimCurrency
dbo.FactCurrencyRate		dbo.DimCurrency	dbo.FactCurrencyRate.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_FactCurrencyRate_DimCurrency
dbo.FactCurrencyRate.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactCurrencyRate_DimCurrency
dbo.FactInternetSales		dbo.DimCurrency	dbo.FactInternetSales.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_FactInternetSales_DimCurrency
dbo.FactInternetSales.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactInternetSales_DimCurrency
dbo.FactResellerSales		dbo.DimCurrency	dbo.FactResellerSales.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_FactResellerSales_DimCurrency
dbo.FactResellerSales.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactResellerSales_DimCurrency

Unique keys

	Key name	Columns	Description
	PK_DimCurrency_CurrencyKey	CurrencyKey
	AK_DimCurrency_CurrencyAlternateKey	CurrencyAlternateKey

Used by

Name
dbo.DimCurrency
dbo.DimOrganization
dbo.FactCurrencyRate
dbo.FactInternetSales
dbo.FactResellerSales

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