[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1438  >   <  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
SO45686_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45687_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45688_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45689_1AustraliaAustraliaAustralia
SO45690_1AustraliaAustraliaAustralia
SO45691_1AustraliaAustraliaAustralia
SO45692_1GermanyGermanyGermany
SO45693_1United KingdomUnited KingdomUnited Kingdom
SO45694_1United KingdomUnited KingdomUnited Kingdom
SO45695_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45696_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45697_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45698_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45699_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45700_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45701_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45702_1FranceFranceFrance
SO45703_1AustraliaAustraliaAustralia
SO45704_1GermanyGermanyGermany
SO45705_1CanadaCanadaCanada
SO45706_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45707_1AustraliaAustraliaAustralia
SO45708_1AustraliaAustraliaAustralia
SO45709_1AustraliaAustraliaAustralia
SO45710_1AustraliaAustraliaAustralia
SO45711_1AustraliaAustraliaAustralia
SO45712_1AustraliaAustraliaAustralia
SO45846_1CanadaCanadaCanada
SO45847_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45848_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45849_1AustraliaAustraliaAustralia

Generated 2024-11-13 01:25:57.607 UTC