[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1042  >   <  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
SO45107_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45108_1CanadaCanadaCanada
SO45109_1United KingdomUnited KingdomUnited Kingdom
SO45110_1AustraliaAustraliaAustralia
SO45111_1AustraliaAustraliaAustralia
SO45112_1United KingdomUnited KingdomUnited Kingdom
SO45113_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45114_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45115_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45116_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45117_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45118_1AustraliaAustraliaAustralia
SO45119_1AustraliaAustraliaAustralia
SO45120_1AustraliaAustraliaAustralia
SO45121_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45122_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45123_1CanadaCanadaCanada
SO45124_1AustraliaAustraliaAustralia
SO45125_1AustraliaAustraliaAustralia
SO45126_1FranceFranceFrance
SO45127_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45128_1AustraliaAustraliaAustralia
SO45129_1AustraliaAustraliaAustralia
SO45130_1United KingdomUnited KingdomUnited Kingdom
SO45131_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45132_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45133_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45134_1CanadaCanadaCanada

Generated 2025-07-09 03:28:29.956 UTC