[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1620  >   <  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
SO45501_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46019_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45923_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45987_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45502_1CanadaCanadaCanada
SO46020_1AustraliaAustraliaAustralia
SO45924_1GermanyGermanyGermany
SO45988_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45503_1CanadaCanadaCanada
SO46021_1AustraliaAustraliaAustralia
SO45925_1AustraliaAustraliaAustralia
SO45989_1FranceFranceFrance
SO45504_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46022_1AustraliaAustraliaAustralia
SO45926_1CanadaCanadaCanada
SO45990_1FranceFranceFrance
SO45505_1AustraliaAustraliaAustralia
SO46108_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45927_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45991_1AustraliaAustraliaAustralia
SO45506_1AustraliaAustraliaAustralia
SO46109_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45928_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45992_1GermanyGermanyGermany
SO45507_1AustraliaAustraliaAustralia
SO46110_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45929_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45993_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45508_1FranceFranceFrance
SO46111_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45930_1FranceFranceFrance

Generated 2025-07-07 13:10:59.687 UTC