[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1500  >   <  TAKE 31  >   TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales   

Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales

31 items

FactInternetSaleIdSalesTerritoryDimCustomer.DimGeography.DimSalesTerritory.NameDimSalesTerritory.Name
SO45724_1FranceFranceFrance
SO45725_1GermanyGermanyGermany
SO45726_1FranceFranceFrance
SO45727_1AustraliaAustraliaAustralia
SO45728_1GermanyGermanyGermany
SO45729_1United KingdomUnited KingdomUnited Kingdom
SO45730_1FranceFranceFrance
SO45731_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45732_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45733_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45734_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45735_1AustraliaAustraliaAustralia
SO45736_1AustraliaAustraliaAustralia
SO45737_1AustraliaAustraliaAustralia
SO45738_1AustraliaAustraliaAustralia
SO45739_1AustraliaAustraliaAustralia
SO45740_1AustraliaAustraliaAustralia
SO45741_1AustraliaAustraliaAustralia
SO45742_1AustraliaAustraliaAustralia
SO45743_1AustraliaAustraliaAustralia
SO45744_1AustraliaAustraliaAustralia
SO45745_1United KingdomUnited KingdomUnited Kingdom
SO45746_1CanadaCanadaCanada
SO45747_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45748_1FranceFranceFrance
SO45749_1GermanyGermanyGermany
SO45750_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45751_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45752_1AustraliaAustraliaAustralia
SO45886_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45887_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-09-20 02:55:16.704 UTC