dbo.DimOrganization - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimOrganization
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		OrganizationKey	int		Identity
Identity
	2		ParentOrganizationKey	int			dbo.DimOrganization
References: dbo.DimOrganization
	3		PercentageOfOwnership	nvarchar(16)
	4		OrganizationName	nvarchar(50)
	5		CurrencyKey	int			dbo.DimCurrency
References: dbo.DimCurrency

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.DimOrganization		dbo.DimOrganization	dbo.DimOrganization.ParentOrganizationKey = dbo.DimOrganization.OrganizationKey	FK_DimOrganization_DimOrganization
dbo.DimOrganization.ParentOrganizationKey = dbo.DimOrganization.OrganizationKey Name: FK_DimOrganization_DimOrganization
dbo.DimOrganization		dbo.DimOrganization	dbo.DimOrganization.ParentOrganizationKey = dbo.DimOrganization.OrganizationKey	FK_DimOrganization_DimOrganization
dbo.DimOrganization.ParentOrganizationKey = dbo.DimOrganization.OrganizationKey Name: FK_DimOrganization_DimOrganization
dbo.FactFinance		dbo.DimOrganization	dbo.FactFinance.OrganizationKey = dbo.DimOrganization.OrganizationKey	FK_FactFinance_DimOrganization
dbo.FactFinance.OrganizationKey = dbo.DimOrganization.OrganizationKey Name: FK_FactFinance_DimOrganization

Unique keys

	Key name	Columns	Description
	PK_DimOrganization	OrganizationKey

Uses

Name
dbo.DimOrganization
dbo.DimCurrency
dbo.DimOrganization

Used by

Name
dbo.DimOrganization
dbo.DimOrganization
dbo.FactFinance

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