[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1042  >   <  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
SO44971_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44972_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44973_1AustraliaAustraliaAustralia
SO44974_1United KingdomUnited KingdomUnited Kingdom
SO44975_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44976_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44977_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
SO45135_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45136_1AustraliaAustraliaAustralia
SO45137_1AustraliaAustraliaAustralia

Generated 2025-07-10 13:11:21.408 UTC