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

Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales

30 items

FactInternetSaleIdSalesTerritoryDimCustomer.DimGeography.DimSalesTerritory.NameDimSalesTerritory.Name
SO45225_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45242_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45243_1AustraliaAustraliaAustralia
SO45244_1AustraliaAustraliaAustralia
SO45245_1AustraliaAustraliaAustralia
SO45246_1AustraliaAustraliaAustralia
SO45247_1AustraliaAustraliaAustralia
SO45248_1AustraliaAustraliaAustralia
SO45249_1United KingdomUnited KingdomUnited Kingdom
SO45250_1GermanyGermanyGermany
SO45251_1GermanyGermanyGermany
SO45252_1CanadaCanadaCanada
SO45253_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45254_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45255_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45256_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45257_1AustraliaAustraliaAustralia
SO45258_1AustraliaAustraliaAustralia
SO45259_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45260_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45261_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45262_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45263_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45264_1AustraliaAustraliaAustralia
SO45265_1AustraliaAustraliaAustralia
SO45345_1United KingdomUnited KingdomUnited Kingdom
SO45346_1CanadaCanadaCanada
SO45347_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45348_1AustraliaAustraliaAustralia
SO45349_1AustraliaAustraliaAustralia

Generated 2025-07-09 00:55:58.914 UTC