[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 9687  >   <  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
SO53055_4United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53081_1GermanyGermanyGermany
SO53056_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53081_2GermanyGermanyGermany
SO53056_2United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53081_3GermanyGermanyGermany
SO53056_3United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53082_1United KingdomUnited KingdomUnited Kingdom
SO53056_4United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53082_2United KingdomUnited KingdomUnited Kingdom
SO53057_1GermanyGermanyGermany
SO53082_3United KingdomUnited KingdomUnited Kingdom
SO53057_2GermanyGermanyGermany
SO53082_4United KingdomUnited KingdomUnited Kingdom
SO53058_1GermanyGermanyGermany
SO53083_1FranceFranceFrance
SO53058_2GermanyGermanyGermany
SO53083_2FranceFranceFrance
SO53058_3GermanyGermanyGermany
SO53083_3FranceFranceFrance
SO53058_4GermanyGermanyGermany
SO53084_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO53059_1AustraliaAustraliaAustralia
SO53085_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53059_2AustraliaAustraliaAustralia
SO53085_2United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO53140_1AustraliaAustraliaAustralia
SO53116_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO53140_2AustraliaAustraliaAustralia
SO53116_2United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO53141_1United KingdomUnited KingdomUnited Kingdom

Generated 2025-07-05 16:01:11.653 UTC