[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 2247  >   <  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
SO46850_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46786_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46851_1CanadaCanadaCanada
SO46787_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46852_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46788_1AustraliaAustraliaAustralia
SO46853_1AustraliaAustraliaAustralia
SO46789_1FranceFranceFrance
SO46854_1AustraliaAustraliaAustralia
SO46790_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46855_1GermanyGermanyGermany
SO46791_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46856_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46792_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46857_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46793_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46858_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46794_1CanadaCanadaCanada
SO46859_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46795_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46860_1AustraliaAustraliaAustralia
SO46796_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46861_1AustraliaAustraliaAustralia
SO46797_1AustraliaAustraliaAustralia
SO46862_1United KingdomUnited KingdomUnited Kingdom
SO46798_1AustraliaAustraliaAustralia
SO46863_1United KingdomUnited KingdomUnited Kingdom
SO46799_1FranceFranceFrance
SO46864_1United KingdomUnited KingdomUnited Kingdom
SO46800_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46865_1GermanyGermanyGermany

Generated 2025-07-07 18:52:58.564 UTC