[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1  >   <  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
SO44321_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO43698_1FranceFranceFrance
SO43699_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44045_1FranceFranceFrance
SO44322_1FranceFranceFrance
SO43700_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43701_1AustraliaAustraliaAustralia
SO44046_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44323_1AustraliaAustraliaAustralia
SO43702_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43703_1AustraliaAustraliaAustralia
SO44047_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44324_1FranceFranceFrance
SO43704_1AustraliaAustraliaAustralia
SO43705_1AustraliaAustraliaAustralia
SO44048_1AustraliaAustraliaAustralia
SO44325_1AustraliaAustraliaAustralia
SO43706_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43707_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44049_1GermanyGermanyGermany
SO44334_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43708_1United KingdomUnited KingdomUnited Kingdom
SO43709_1AustraliaAustraliaAustralia
SO44050_1AustraliaAustraliaAustralia
SO44335_1United KingdomUnited KingdomUnited Kingdom
SO43710_1AustraliaAustraliaAustralia
SO43711_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44051_1United KingdomUnited KingdomUnited Kingdom
SO44336_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO43712_1GermanyGermanyGermany
SO43713_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-11-10 06:54:58.362 UTC