dbo.FactFinance - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	FactFinance
Module	Finance

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		FinanceKey	int		Identity
Identity
	2		DateKey	int			dbo.DimDate
References: dbo.DimDate
	3		OrganizationKey	int			dbo.DimOrganization
References: dbo.DimOrganization
	4		DepartmentGroupKey	int			dbo.DimDepartmentGroup
References: dbo.DimDepartmentGroup
	5		ScenarioKey	int			dbo.DimScenario
References: dbo.DimScenario
	6		AccountKey	int			dbo.DimAccount
References: dbo.DimAccount
	7		Amount	float
	8		Date	datetime

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.FactFinance		dbo.DimAccount	dbo.FactFinance.AccountKey = dbo.DimAccount.AccountKey	FK_FactFinance_DimAccount
dbo.FactFinance.AccountKey = dbo.DimAccount.AccountKey Name: FK_FactFinance_DimAccount
dbo.FactFinance		dbo.DimDate	dbo.FactFinance.DateKey = dbo.DimDate.DateKey	FK_FactFinance_DimDate
dbo.FactFinance.DateKey = dbo.DimDate.DateKey Name: FK_FactFinance_DimDate
dbo.FactFinance		dbo.DimDepartmentGroup	dbo.FactFinance.DepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey	FK_FactFinance_DimDepartmentGroup
dbo.FactFinance.DepartmentGroupKey = dbo.DimDepartmentGroup.DepartmentGroupKey Name: FK_FactFinance_DimDepartmentGroup
dbo.FactFinance		dbo.DimOrganization	dbo.FactFinance.OrganizationKey = dbo.DimOrganization.OrganizationKey	FK_FactFinance_DimOrganization
dbo.FactFinance.OrganizationKey = dbo.DimOrganization.OrganizationKey Name: FK_FactFinance_DimOrganization
dbo.FactFinance		dbo.DimScenario	dbo.FactFinance.ScenarioKey = dbo.DimScenario.ScenarioKey	FK_FactFinance_DimScenario
dbo.FactFinance.ScenarioKey = dbo.DimScenario.ScenarioKey Name: FK_FactFinance_DimScenario

Uses

Name
dbo.FactFinance
dbo.DimAccount
dbo.DimDate
dbo.DimDepartmentGroup
dbo.DimOrganization
dbo.DimScenario

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