[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 374  >   <  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
SO44190_1AustraliaAustraliaAustralia
SO44046_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44182_1AustraliaAustraliaAustralia
SO44391_1AustraliaAustraliaAustralia
SO44191_1AustraliaAustraliaAustralia
SO44047_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44183_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44392_1AustraliaAustraliaAustralia
SO44192_1GermanyGermanyGermany
SO44048_1AustraliaAustraliaAustralia
SO44184_1AustraliaAustraliaAustralia
SO44393_1GermanyGermanyGermany
SO44217_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44073_1AustraliaAustraliaAustralia
SO44209_1AustraliaAustraliaAustralia
SO44394_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44218_1CanadaCanadaCanada
SO44134_1United KingdomUnited KingdomUnited Kingdom
SO44210_1United KingdomUnited KingdomUnited Kingdom
SO44395_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44219_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44135_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44211_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44396_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44220_1AustraliaAustraliaAustralia
SO44136_1CanadaCanadaCanada
SO44212_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44397_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44221_1AustraliaAustraliaAustralia
SO44137_1AustraliaAustraliaAustralia
SO44213_1AustraliaAustraliaAustralia

Generated 2024-11-10 06:40:04.164 UTC