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

Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales

28 items

FactInternetSaleIdSalesTerritoryDimCustomer.DimGeography.DimSalesTerritory.NameDimSalesTerritory.Name
SO52446_3CanadaCanadaCanada
SO52447_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO52447_2United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO52447_3United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO52448_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO52500_2United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO52501_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52501_2United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52502_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52502_2United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52502_3United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52502_4United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO52503_1United KingdomUnited KingdomUnited Kingdom
SO52474_2AustraliaAustraliaAustralia
SO52474_3AustraliaAustraliaAustralia
SO52475_1AustraliaAustraliaAustralia
SO52475_2AustraliaAustraliaAustralia
SO52475_3AustraliaAustraliaAustralia
SO52475_4AustraliaAustraliaAustralia
SO52476_1AustraliaAustraliaAustralia
SO52477_1AustraliaAustraliaAustralia
SO52478_1AustraliaAustraliaAustralia
SO52479_1GermanyGermanyGermany
SO52479_2GermanyGermanyGermany
SO52480_1United KingdomUnited KingdomUnited Kingdom
SO52480_2United KingdomUnited KingdomUnited Kingdom
SO52481_1FranceFranceFrance
SO52481_2FranceFranceFrance

Generated 2025-07-09 01:39:20.999 UTC