[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 2094  >   <  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
SO46509_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46446_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46510_1CanadaCanadaCanada
SO46447_1AustraliaAustraliaAustralia
SO46511_1CanadaCanadaCanada
SO46448_1AustraliaAustraliaAustralia
SO46512_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46449_1AustraliaAustraliaAustralia
SO46513_1CanadaCanadaCanada
SO46450_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46514_1FranceFranceFrance
SO46451_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46515_1GermanyGermanyGermany
SO46452_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46516_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO46453_1AustraliaAustraliaAustralia
SO46517_1AustraliaAustraliaAustralia
SO46454_1AustraliaAustraliaAustralia
SO46518_1AustraliaAustraliaAustralia
SO46455_1United KingdomUnited KingdomUnited Kingdom
SO46519_1United KingdomUnited KingdomUnited Kingdom
SO46456_1AustraliaAustraliaAustralia
SO46520_1CanadaCanadaCanada
SO46457_1AustraliaAustraliaAustralia
SO46521_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46458_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46522_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46459_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46523_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46460_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO46524_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-11-10 08:38:56.022 UTC