[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1022  >   <  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
SO45225_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45129_1AustraliaAustraliaAustralia
SO45025_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45401_1United KingdomUnited KingdomUnited Kingdom
SO45226_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45130_1United KingdomUnited KingdomUnited Kingdom
SO45026_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45402_1United KingdomUnited KingdomUnited Kingdom
SO45227_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45131_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45027_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45403_1CanadaCanadaCanada
SO45228_1AustraliaAustraliaAustralia
SO45132_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45028_1AustraliaAustraliaAustralia
SO45404_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45229_1United KingdomUnited KingdomUnited Kingdom
SO45133_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45029_1AustraliaAustraliaAustralia
SO45405_1CanadaCanadaCanada
SO45230_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45134_1CanadaCanadaCanada
SO45030_1AustraliaAustraliaAustralia
SO45406_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45231_1AustraliaAustraliaAustralia
SO45135_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45031_1United KingdomUnited KingdomUnited Kingdom
SO45407_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45232_1AustraliaAustraliaAustralia
SO45136_1AustraliaAustraliaAustralia
SO45032_1GermanyGermanyGermany

Generated 2025-07-09 03:53:02.042 UTC