[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 2767  >   <  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
SO47320_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47321_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47322_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47323_1FranceFranceFrance
SO47324_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47325_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47326_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47327_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47328_1AustraliaAustraliaAustralia
SO47329_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47330_1United KingdomUnited KingdomUnited Kingdom
SO47331_1United KingdomUnited KingdomUnited Kingdom
SO47332_1CanadaCanadaCanada
SO47333_1AustraliaAustraliaAustralia
SO47334_1AustraliaAustraliaAustralia
SO47335_1AustraliaAustraliaAustralia
SO47336_1AustraliaAustraliaAustralia
SO47337_1FranceFranceFrance
SO47338_1United KingdomUnited KingdomUnited Kingdom
SO47339_1GermanyGermanyGermany
SO47340_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47341_1CanadaCanadaCanada
SO47342_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47343_1AustraliaAustraliaAustralia
SO47344_1AustraliaAustraliaAustralia
SO47345_1AustraliaAustraliaAustralia
SO47346_1AustraliaAustraliaAustralia
SO47347_1AustraliaAustraliaAustralia
SO47348_1AustraliaAustraliaAustralia
SO47460_1FranceFranceFrance
SO47461_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2025-07-19 12:23:43.810 UTC