Data Warehouse – Data Dictionary
Sample Dataedo documentationData warehouseDocumentation2017-09-01
Table of Contents1. Dimensions . 51.1. Tables . 51.1.1. Table: dbo.DimAccount . 51.1.2. Table: dbo.DimCurrency . 61.1.3. Table: dbo.DimCustomer .61.1.4. Table: dbo.DimDate . 81.1.5. Table: dbo.DimDepartmentGroup . 101.1.6. Table: dbo.DimEmployee .111.1.7. Table: dbo.DimGeography . 121.1.8. Table: dbo.DimOrganization . 131.1.9. Table: dbo.DimProduct . 141.1.10. Table: dbo.DimProductCategory . 161.1.11. Table: dbo.DimProductSubcategory . 171.1.12. Table: dbo.DimPromotion . 181.1.13. Table: dbo.DimReseller . 191.1.14. Table: dbo.DimSalesReason . 201.1.15. Table: dbo.DimSalesTerritory . 211.1.16. Table: dbo.DimScenario . 222. Finance . 232.1. Tables . 232.1.1. Table: dbo.FactFinance . 233. Call Center . 253.1. Tables . 253.1.1. Table: dbo.FactCallCenter . 254. Inventory . 274.1. Tables . 274.1.1. Table: dbo.FactProductInventory . 275. Internet Sales .295.1. Tables . 295.1.1. Table: dbo.FactInternetSales .295.1.2. Table: dbo.FactInternetSalesReason . 316. Sales Quotas . 336.1. Tables . 336.1.1. Table: dbo.FactSalesQuota . 337. Surveys . 347.1. Tables . 347.1.1. Table: dbo.FactSurveyResponse . 348. Currency Rates .358.1. Tables . 358.1.1. Table: dbo.FactCurrencyRate . 359. Reseller Sales .369.1. Tables . 369.1.1. Table: dbo.FactResellerSales . 3610. Product Descriptions . 3910.1. Tables . 39
10.1.1. Table: dbo.FactAdditionalInternationalProductDescription . 39
LegendPrimary keyPrimary key disabledUser-defined primary keyUnique keyUnique key disabledUser-defined unique keyActive triggerDisabled triggerPrimary key relationUser-defined primary key relationForeign key relationUser-defined foreign key relationInputOutputInput/OutputNullable4
1. Dimensions1.1. Tables1.1.1. Table: dbo.DimAccountColumnsNameData cription / AttributesIdentity / Auto increment columnLinks toTabledbo.DimAccountJoinTitle / Name / Descriptiondbo.DimAccount.ParentAccountKey dbo.DimAccount.AccountKeyFK DimAccount DimAccountLinked fromTableJoinTitle / Name / Descriptiondbo.DimAccountdbo.DimAccount.AccountKey dbo.DimAccount.ParentAccountKeyFK DimAccount DimAccountdbo.FactFinancedbo.DimAccount.AccountKey dbo.FactFinance.AccountKeyFK FactFinance DimAccountUnique keysColumnsName / DescriptionAccountKeyPK DimAccountTable Primary Key / IDAccountCodeAlternateKeyAK DimAccount AccountCodeAlternateKeyBusiness KeyUsesNamedbo.DimAccountdbo.DimAccount5
Used .1.2. Table: dbo.DimCurrencyColumnsNameData encyNamenvarchar(50)NDescription / AttributesIdentity / Auto increment columnLinked fromTableJoinTitle / Name / encyKey dbo.DimOrganization.CurrencyKeyFK DimOrganization rencyKey dbo.FactCurrencyRate.CurrencyKeyFK FactCurrencyRate rrencyKey dbo.FactInternetSales.CurrencyKeyFK FactInternetSales rrencyKey dbo.FactResellerSales.CurrencyKeyFK FactResellerSales DimCurrencyUnique keysColumnsName / DescriptionCurrencyKeyPK DimCurrency CurrencyKeyTable Primary Key / IDCurrencyAlternateKeyAK DimCurrency CurrencyAlternateKeyBusiness KeyUsed es1.1.3. Table: dbo.DimCustomerColumnsNameCustomerKey6Data typeintNDescription / AttributesIdentity / Auto increment column
NameData ateCommuteDistancenvarchar(15)NDescription / AttributesLinks hyKey dbo.DimGeography.GeographyKeyTitle / Name / DescriptionFK DimCustomer DimGeographyLinked fromTable7JoinTitle / Name / stomerKey dbo.FactInternetSales.CustomerKeyFK FactInternetSales ustomerKey dbo.FactSurveyResponse.CustomerKeyFK FactSurveyResponse CustomerKey
Unique keysColumnsName / DescriptionCustomerKeyPK DimCustomer CustomerKeyTable Primary Key / IDCustomerAlternateKeyIX DimCustomer CustomerAlternateKeyBusiness KeyUsesNamedbo.DimCustomerdbo.DimGeographyUsed .FactInternetSalesdbo.FactSurveyResponse1.1.4. Table: dbo.DimDateColumnsName8Data alQuartertinyintFiscalYearsmallintNDescription / Attributes
NameFiscalSemesterData typeNDescription / AttributestinyintLinked fromTableJoinTitle / Name / Descriptiondbo.FactCallCenterdbo.DimDate.DateKey dbo.FactCallCenter.DateKeyFK FactCallCenter DimDatedbo.FactCurrencyRatedbo.DimDate.DateKey dbo.FactCurrencyRate.DateKeyFK FactCurrencyRate DimDatedbo.FactFinancedbo.DimDate.DateKey dbo.FactFinance.DateKeyFK FactFinance DimDatedbo.FactInternetSalesdbo.DimDate.DateKey dbo.FactInternetSales.OrderDateKeyOrder DataFK FactInternetSales DimDatedbo.FactInternetSalesdbo.DimDate.DateKey dbo.FactInternetSales.DueDateKeyDue DateFK FactInternetSales DimDate1dbo.FactInternetSalesdbo.DimDate.DateKey dbo.FactInternetSales.ShipDateKeyShip DateFK FactInternetSales y dbo.FactProductInventory.DateKeyFK FactProductInventory DimDatedbo.FactResellerSalesdbo.DimDate.DateKey dbo.FactResellerSales.OrderDateKeyOrder DateFK FactResellerSales DimDatedbo.FactResellerSalesdbo.DimDate.DateKey dbo.FactResellerSales.DueDateKeyDue DateFK FactResellerSales DimDate1dbo.FactResellerSalesdbo.DimDate.DateKey dbo.FactResellerSales.ShipDateKeyShip DateFK FactResellerSales DimDate2dbo.FactSalesQuotadbo.DimDate.DateKey dbo.FactSalesQuota.DateKeyFK FactSalesQuota DimDatedbo.FactSurveyResponsedbo.DimDate.DateKey dbo.FactSurveyResponse.DateKeyFK FactSurveyResponse DateKeyUnique keysColumnsName / DescriptionDateKeyPK DimDate DateKeyTable Primary Key / IDFullDateAlternateKeyAK DimDate FullDateAlternateKeyBusiness KeyUsed es (Due Date)dbo.FactInternetSales (Order Data)dbo.FactInternetSales (Ship Date)9
Namedbo.FactProductInventorydbo.FactResellerSales (Due Date)dbo.FactResellerSales (Order Date)dbo.FactResellerSales (Ship . Table: dbo.DimDepartmentGroupColumnsNameData ntDepartmentGroupNamenvarchar(50)NDescription / AttributesIdentity / Auto increment columnLinks toTabledbo.DimDepartmentGroupJoinTitle / Name / GroupKey dbo.DimDepartmentGroup.DepartmentGroupKeyFK DimDepartmentGroup DimDepartmentGroupLinked fromTableJoinTitle / Name / Group.DepartmentGroupKey dbo.DimDepartmentGroup.ParentDepartmentGroupKeyFK DimDepartmentGroup Group.DepartmentGroupKey dbo.FactFinance.DepartmentGroupKeyFK FactFinance DimDepartmentGroupUnique keysColumnsDepartmentGroupKeyName / DescriptionPK DimDepartmentGroupTable Primary Key / roupUsed byNamedbo.DimDepartmentGroup10
Namedbo.DimDepartmentGroupdbo.FactFinance1.1.6. Table: dbo.DimEmployeeColumnsName11Data ption / AttributesIdentity / Auto increment column
Links toTableJoinTitle / Name / ployeeKey dbo.DimEmployee.EmployeeKeyFK DimEmployee lesTerritoryKey dbo.DimSalesTerritory.SalesTerritoryKeyFK DimEmployee DimSalesTerritoryLinked fromTableJoinTitle / Name / Key dbo.DimEmployee.ParentEmployeeKeyFK DimEmployee ployeeKey dbo.FactResellerSales.EmployeeKeyFK FactResellerSales yeeKey dbo.FactSalesQuota.EmployeeKeyFK FactSalesQuota DimEmployeeUnique keysColumnsName / DescriptionPK DimEmployee EmployeeKeyTable Primary Key / edbo.DimSalesTerritoryUsed erSalesdbo.FactSalesQuota1.1.7. Table: dbo.DimGeographyColumnsName12Data ar(50)NDescription / AttributesIdentity / Auto increment column
NameData ription / AttributesLinks toTabledbo.DimSalesTerritoryJoinTitle / Name / Descriptiondbo.DimGeography.SalesTerritoryKey dbo.DimSalesTerritory.SalesTerritoryKeyFK DimGeography DimSalesTerritoryLinked fromTableJoinTitle / Name / hyKey dbo.DimCustomer.GeographyKeyFK DimCustomer phyKey dbo.DimReseller.GeographyKeyFK DimReseller DimGeographyUnique keysColumnsName / DescriptionPK DimGeography GeographyKeyTable Primary Key / TerritoryUsed o.DimReseller1.1.8. Table: dbo.DimOrganizationColumnsName13Data har(50)NDescription / AttributesIdentity / Auto increment column
NameCurrencyKeyData typeNDescription / AttributesintLinks toTableJoinTitle / Name / encyKey DimOrganization.ParentOrganizationKey FK DimOrganization FK DimOrganization DimCurrencyLinked fromTableJoinTitle / Name / OrganizationKey FK DimOrganization ionKey dbo.FactFinance.OrganizationKeyFK FactFinance DimOrganizationUnique keysColumnsOrganizationKeyName / DescriptionPK DimOrganizationTable Primary Key / mOrganizationUsed ctFinance1.1.9. Table: dbo.DimProductColumnsName14Data )SizeUnitMeasureCodenchar(3)NDescription / AttributesIdentity / Auto increment column
NameData )NDescription / AttributesLinks ct.ProductSubcategoryKey le / Name / DescriptionFK DimProduct DimProductSubcategory
Linked fromTableJoinTitle / Name / escriptiondbo.DimProduct.ProductKey ProductKeyUser-defined tKey dbo.FactInternetSales.ProductKeyFK FactInternetSales roductKey dbo.FactProductInventory.ProductKeyFK FactProductInventory uctKey dbo.FactResellerSales.ProductKeyFK FactResellerSales DimProductUnique keysColumnsName / DescriptionProductKeyPK DimProduct ProductKeyTable Primary Key / IDProductAlternateKey, StartDateAK DimProduct ProductAlternateKey StartDateBusiness Used 10. Table: dbo.DimProductCategoryColumnsName16Data ryNamenvarchar(50)NDescription / AttributesIdentity / Auto increment column
Linked fromTabledbo.DimProductSubcategoryJoinTitle / Name / ey dbo.DimProductSubcategory.ProductCategoryKeyFK DimProductSubcategory DimProductCategoryUnique keysColumnsName / DescriptionProductCategoryKeyPK DimProductCategory ProductCategoryKeyTable Primary Key / IDProductCategoryAlternateKeyAK DimProductCategory ProductCategoryAlternateKeyBusiness KeyUsed uctSubcategory1.1.11. Table: dbo.DimProductSubcategoryColumnsNameData yintNDescription / AttributesIdentity / Auto increment columnLinks category.ProductCategoryKey dbo.DimProductCategory.ProductCategoryKeyTitle / Name / DescriptionFK DimProductSubcategory DimProductCategoryLinked gory.ProductSubcategoryKey dbo.DimProduct.ProductSubcategoryKeyTitle / Name / DescriptionFK DimProduct DimProductSubcategory
Unique keysColumnsName / DescriptionProductSubcategoryKeyPK DimProductSubcategory ProductSubcategoryKeyTable Primary Key / IDProductSubcategoryAlternateKeyAK DimProductSubcategory ProductSubcategoryAlternateKeyBusiness CategoryUsed roduct1.1.12. Table: dbo.DimPromotionColumnsNameData MaxQtyintNDescription / AttributesIdentity / Auto increment columnLinked on.PromotionKey dbo.FactInternetSales.PromotionKeyTitle / Name / DescriptionFK FactInternetSales DimPromotion
Tabledbo.FactResellerSalesJoinTitle / Name / Descriptiondbo.DimPromotion.PromotionKey dbo.FactResellerSales.PromotionKeyFK FactResellerSales DimPromotionUnique keysColumnsName / DescriptionPromotionKeyPK DimPromotion PromotionKeyTable Primary Key / IDPromotionAlternateKeyAK DimPromotion PromotionAlternateKeyBusiness KeyUsed tResellerSales1.1.13. Table: dbo.DimResellerColumnsName19Data escription / AttributesIdentity / Auto increment column
Links toTabledbo.DimGeographyJoinTitle / Name / Descriptiondbo.DimReseller.GeographyKey dbo.DimGeography.GeographyKeyFK DimReseller DimGeographyLinked fromTabledbo.FactResellerSalesJoinTitle / Name / Descriptiondbo.DimReseller.ResellerKey dbo.FactResellerSales.ResellerKeyFK FactResellerSales DimResellerUnique keysColumnsName / DescriptionResellerKeyPK DimReseller ResellerKeyTable Primary Key / IDResellerAlternateKeyAK DimReseller ResellerAlternateKeyBusiness KeyUsesNamedbo.DimResellerdbo.DimGeographyUsed byNamedbo.DimResellerdbo.FactResellerSales1.1.14. Table: dbo.DimSalesReasonColumnsNameData har(50)NDescription / AttributesIdentity / Auto increment columnLinked esReason.SalesReasonKey dbo.FactInternetSalesReason.SalesReasonKeyTitle / Name / DescriptionFK FactInternetSalesReason DimSalesReasonUnique keysColumnsSalesReasonKey20Name / DescriptionPK DimSalesReason SalesReasonKeyTable Primary Key / ID
Used n1.1.15. Table: dbo.DimSalesTerritoryColumnsNameData alesTerritoryImagevarbinary(MAX)NDescription / AttributesIdentity / Auto increment columnLinked fromTableJoinTitle / Name / lesTerritoryKey dbo.DimEmployee.SalesTerritoryKeyFK DimEmployee tory.SalesTerritoryKey dbo.DimGeography.SalesTerritoryKeyFK DimGeography Territory.SalesTerritoryKey dbo.FactInternetSales.SalesTerritoryKeyFK FactInternetSales Territory.SalesTerritoryKey dbo.FactResellerSales.SalesTerritoryKeyFK FactResellerSales DimSalesTerritoryUnique keysColumnsName / DescriptionSalesTerritoryKeyPK DimSalesTerritory SalesTerritoryKeyTable Primary Key / IDSalesTerritoryAlternateKeyAK DimSalesTerritory SalesTerritoryAlternateKeyBusiness KeyUsed yeedbo.DimGeographydbo.FactInternetSales21
Namedbo.FactResellerSales1.1.16. Table: dbo.DimScenarioColumnsNameData tion / AttributesIdentity / Auto increment columnLinked fromTabledbo.FactFinanceJoinTitle / Name / Descriptiondbo.DimScenario.ScenarioKey dbo.FactFinance.ScenarioKeyFK FactFinance DimScenarioUnique keysColumnsScenarioKeyName / DescriptionPK DimScenarioTable Primary Key / IDUsed byNamedbo.DimScenariodbo.FactFinance22
2. Finance2.1. Tables2.1.1. Table: dbo.FactFinanceColumnsNameData loatDatedatetimeNDescription / AttributesIdentity / Auto increment columnLinks toTable2
Sep 01, 2017 · Data warehouse Documentation 2017-09-01. Table of Contents 1. . Name Data type N Description / Attributes AccountKey int Identity / Auto increment column ParentAccountKey int AccountCodeAlternateKey int ParentAc
Management under Master Data Define Warehouse Numbers. 2. Check the warehouse number assignment in Customizing for Extended Warehouse Management under Master Data Assign Warehouse Numbers. 3. Check the warehouse number control in Customizing for Extended Warehouse Management under Master Data Define Warehouse Number Control.
aspell-eo An Esperanto Dictionary for Aspell L2 aspell-es A Spanish Dictionary for ASpell L2 aspell-et An Estonian dictionary for aspell L2 aspell-fa A Persian dictionary for aspell L2 aspell-fi Finnish Dictionary Package L2 aspell-fo A Faroese Dictionary for ASpell L2 aspell-fr A French Dictionary for ASpell L2 aspell-ga An Irish Dictionary .
location: fort worth, tx warehouse status: approved county: tarrant warehouse capacity: 85,000 warehouse code: 853007 001 location(s) warehouse name: eugene b smith & company , inc license type: unlicensed location: galveston, tx warehouse status: approved county: galveston warehouse capacity: 37,180 warehouse code: 858054 001 location(s)
location: fort worth, tx warehouse status: approved county: tarrant warehouse capacity: 85,000 warehouse code: 853007 001 location(s) warehouse name: eugene b smith & company , inc license type: unlicensed location: galveston, tx warehouse status: approved county: galveston warehouse capacity: 37,180 warehouse code: 858054 001 location(s)
Dictionary of Accounting 0 7475 6991 6 . Dictionary of Computing 0 7475 6622 4 Dictionary of Economics 0 7136 8203 5 Dictionary of Environment and Ecology 0 7475 7201 1 Dictionary of Food Science and Nutrition 0 7136 7784 8 Dictionary of Human Resources and Personnel Management 0 7136 8142 X
Inventory data Warehouse Outgoing Inventory IoT Cloud gathers warehouse inventory data from Warehouse IoT Cloud gathers dispatched inventory data from Warehouse . Based on the warehouse floor design, budget, type of industry and materials , suitable option or combination of options possible to choose.
1.3 Common Data Warehouse Tasks 1-4 1.4 Data Warehouse Architectures 1-5 1.4.1 Data Warehouse Architecture: Basic 1-5 1.4.2 Data Warehouse Architecture: with a Staging Area 1-6 1.4.3 Data Warehouse Architecture: with a Staging Area and Data Marts 1-6 2 Data Warehousing Logical Design 2.1 Logical Versus Physical Design in Data Warehouses 2-1
warehouse is order picking which is estimated to spend 55% of the total warehouse costs, hence with a good design of the warehouse, this activity will improve, and as a result the performance of the warehouse will improve respectively (Koster et al., 2007). Designing of a warehouse could be based on the order picking system, it could be
