[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 1000  >   <  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
SO45117_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44998_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45118_1AustraliaAustraliaAustralia
SO44999_1AustraliaAustraliaAustralia
SO45119_1AustraliaAustraliaAustralia
SO45000_1AustraliaAustraliaAustralia
SO45120_1AustraliaAustraliaAustralia
SO45001_1AustraliaAustraliaAustralia
SO45121_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45138_1AustraliaAustraliaAustralia
SO45122_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45139_1FranceFranceFrance
SO45123_1CanadaCanadaCanada
SO45140_1FranceFranceFrance
SO45124_1AustraliaAustraliaAustralia
SO45141_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45125_1AustraliaAustraliaAustralia
SO45142_1CanadaCanadaCanada
SO45126_1FranceFranceFrance
SO45143_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45127_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45144_1AustraliaAustraliaAustralia
SO45128_1AustraliaAustraliaAustralia
SO45145_1AustraliaAustraliaAustralia
SO45129_1AustraliaAustraliaAustralia
SO45146_1United KingdomUnited KingdomUnited Kingdom
SO45130_1United KingdomUnited KingdomUnited Kingdom
SO45147_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO45131_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45148_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO45132_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-11-12 23:55:32.483 UTC