[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 3086  >   <  TAKE 28  >   TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales   

Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales

28 items

FactInternetSaleIdSalesTerritoryDimCustomer.DimGeography.DimSalesTerritory.NameDimSalesTerritory.Name
SO48106_1CanadaCanadaCanada
SO47909_1AustraliaAustraliaAustralia
SO47845_1GermanyGermanyGermany
SO48171_1GermanyGermanyGermany
SO48107_1AustraliaAustraliaAustralia
SO47910_1AustraliaAustraliaAustralia
SO47846_1FranceFranceFrance
SO48172_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO48108_1AustraliaAustraliaAustralia
SO47911_1AustraliaAustraliaAustralia
SO47847_1GermanyGermanyGermany
SO48173_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO48109_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47912_1FranceFranceFrance
SO47848_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO48174_1United KingdomUnited KingdomUnited Kingdom
SO48110_1GermanyGermanyGermany
SO47913_1CanadaCanadaCanada
SO47849_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO48175_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO48111_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47914_1GermanyGermanyGermany
SO47850_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO48176_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO48112_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO47915_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO47851_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO48177_1FranceFranceFrance

Generated 2025-07-12 23:00:51.292 UTC