[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6855 > < TAKE 250 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
250 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51900_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51900_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51900_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51901_1 | Germany | Germany | Germany |
SO51901_2 | Germany | Germany | Germany |
SO51901_3 | Germany | Germany | Germany |
SO51902_1 | France | France | France |
SO51902_2 | France | France | France |
SO51902_3 | France | France | France |
SO51903_1 | Germany | Germany | Germany |
SO51903_2 | Germany | Germany | Germany |
SO51903_3 | Germany | Germany | Germany |
SO51904_1 | France | France | France |
SO51904_2 | France | France | France |
SO51904_3 | France | France | France |
SO51905_1 | Germany | Germany | Germany |
SO51905_2 | Germany | Germany | Germany |
SO51906_1 | France | France | France |
SO51907_1 | United Kingdom | United Kingdom | United Kingdom |
SO51907_2 | United Kingdom | United Kingdom | United Kingdom |
SO51908_1 | United Kingdom | United Kingdom | United Kingdom |
SO51908_2 | United Kingdom | United Kingdom | United Kingdom |
SO51909_1 | France | France | France |
SO51909_2 | France | France | France |
SO51910_1 | Canada | Canada | Canada |
SO51910_2 | Canada | Canada | Canada |
SO51911_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51911_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51911_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51912_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51913_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51913_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51913_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51913_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51914_1 | Canada | Canada | Canada |
SO51914_2 | Canada | Canada | Canada |
SO51915_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51915_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51915_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51916_1 | Canada | Canada | Canada |
SO51917_1 | Australia | Australia | Australia |
SO51917_2 | Australia | Australia | Australia |
SO51918_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51918_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51918_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51918_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51919_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51919_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51919_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51919_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51947_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51947_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51948_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51948_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51949_1 | France | France | France |
SO51949_2 | France | France | France |
SO51949_3 | France | France | France |
SO51950_1 | United Kingdom | United Kingdom | United Kingdom |
SO51950_2 | United Kingdom | United Kingdom | United Kingdom |
SO51950_3 | United Kingdom | United Kingdom | United Kingdom |
SO51951_1 | Germany | Germany | Germany |
SO51951_2 | Germany | Germany | Germany |
SO51951_3 | Germany | Germany | Germany |
SO51952_1 | United Kingdom | United Kingdom | United Kingdom |
SO51952_2 | United Kingdom | United Kingdom | United Kingdom |
SO51953_1 | Germany | Germany | Germany |
SO51953_2 | Germany | Germany | Germany |
SO51953_3 | Germany | Germany | Germany |
SO51954_1 | Germany | Germany | Germany |
SO51954_2 | Germany | Germany | Germany |
SO51955_1 | United Kingdom | United Kingdom | United Kingdom |
SO51955_2 | United Kingdom | United Kingdom | United Kingdom |
SO51955_3 | United Kingdom | United Kingdom | United Kingdom |
SO51956_1 | France | France | France |
SO51956_2 | France | France | France |
SO51957_1 | Canada | Canada | Canada |
SO51957_2 | Canada | Canada | Canada |
SO51957_3 | Canada | Canada | Canada |
SO51958_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51958_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51960_1 | United Kingdom | United Kingdom | United Kingdom |
SO51960_2 | United Kingdom | United Kingdom | United Kingdom |
SO51961_1 | Australia | Australia | Australia |
SO51962_1 | Canada | Canada | Canada |
SO51962_2 | Canada | Canada | Canada |
SO51963_1 | France | France | France |
SO51963_2 | France | France | France |
SO51963_3 | France | France | France |
SO51963_4 | France | France | France |
SO51964_1 | Australia | Australia | Australia |
SO51964_2 | Australia | Australia | Australia |
SO51964_3 | Australia | Australia | Australia |
SO51964_4 | Australia | Australia | Australia |
SO51965_1 | Australia | Australia | Australia |
SO51965_2 | Australia | Australia | Australia |
SO51965_3 | Australia | Australia | Australia |
SO51966_1 | Germany | Germany | Germany |
SO51966_2 | Germany | Germany | Germany |
SO51966_3 | Germany | Germany | Germany |
SO51966_4 | Germany | Germany | Germany |
SO51966_5 | Germany | Germany | Germany |
SO51966_6 | Germany | Germany | Germany |
SO51967_1 | Germany | Germany | Germany |
SO51967_2 | Germany | Germany | Germany |
SO51967_3 | Germany | Germany | Germany |
SO51967_4 | Germany | Germany | Germany |
SO51967_5 | Germany | Germany | Germany |
SO51968_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51969_1 | Australia | Australia | Australia |
SO51969_2 | Australia | Australia | Australia |
SO51970_1 | Australia | Australia | Australia |
SO52000_1 | France | France | France |
SO52000_2 | France | France | France |
SO52001_1 | Germany | Germany | Germany |
SO52001_2 | Germany | Germany | Germany |
SO52002_1 | Canada | Canada | Canada |
SO52002_2 | Canada | Canada | Canada |
SO52002_3 | Canada | Canada | Canada |
SO52002_4 | Canada | Canada | Canada |
SO51472_1 | Australia | Australia | Australia |
SO51472_2 | Australia | Australia | Australia |
SO51472_3 | Australia | Australia | Australia |
SO51473_1 | Australia | Australia | Australia |
SO51473_2 | Australia | Australia | Australia |
SO51473_3 | Australia | Australia | Australia |
SO51473_4 | Australia | Australia | Australia |
SO51474_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51474_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51475_1 | Germany | Germany | Germany |
SO51475_2 | Germany | Germany | Germany |
SO51475_3 | Germany | Germany | Germany |
SO51475_4 | Germany | Germany | Germany |
SO51476_1 | United Kingdom | United Kingdom | United Kingdom |
SO51476_2 | United Kingdom | United Kingdom | United Kingdom |
SO51477_1 | United Kingdom | United Kingdom | United Kingdom |
SO51477_2 | United Kingdom | United Kingdom | United Kingdom |
SO51478_1 | Australia | Australia | Australia |
SO51478_2 | Australia | Australia | Australia |
SO51478_3 | Australia | Australia | Australia |
SO51478_4 | Australia | Australia | Australia |
SO51479_1 | Australia | Australia | Australia |
SO51479_2 | Australia | Australia | Australia |
SO51479_3 | Australia | Australia | Australia |
SO51479_4 | Australia | Australia | Australia |
SO51480_1 | France | France | France |
SO51480_2 | France | France | France |
SO51480_3 | France | France | France |
SO51481_1 | United Kingdom | United Kingdom | United Kingdom |
SO51481_2 | United Kingdom | United Kingdom | United Kingdom |
SO51482_1 | Germany | Germany | Germany |
SO51482_2 | Germany | Germany | Germany |
SO51482_3 | Germany | Germany | Germany |
SO51483_1 | United Kingdom | United Kingdom | United Kingdom |
SO51483_2 | United Kingdom | United Kingdom | United Kingdom |
SO51483_3 | United Kingdom | United Kingdom | United Kingdom |
SO51483_4 | United Kingdom | United Kingdom | United Kingdom |
SO51484_1 | United Kingdom | United Kingdom | United Kingdom |
SO51484_2 | United Kingdom | United Kingdom | United Kingdom |
SO51485_1 | Germany | Germany | Germany |
SO51485_2 | Germany | Germany | Germany |
SO51485_3 | Germany | Germany | Germany |
SO51486_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52024_2 | Australia | Australia | Australia |
SO52024_3 | Australia | Australia | Australia |
SO52025_1 | Australia | Australia | Australia |
SO52025_2 | Australia | Australia | Australia |
SO52025_3 | Australia | Australia | Australia |
SO52025_4 | Australia | Australia | Australia |
SO52026_1 | Australia | Australia | Australia |
SO52027_1 | Australia | Australia | Australia |
SO52002_5 | Canada | Canada | Canada |
SO52003_1 | Canada | Canada | Canada |
SO52003_2 | Canada | Canada | Canada |
SO52003_3 | Canada | Canada | Canada |
SO52004_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52004_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52005_1 | Canada | Canada | Canada |
SO52005_2 | Canada | Canada | Canada |
SO52005_3 | Canada | Canada | Canada |
SO52006_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52006_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52007_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52007_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52012_1 | United Kingdom | United Kingdom | United Kingdom |
SO52012_2 | United Kingdom | United Kingdom | United Kingdom |
SO52013_1 | Germany | Germany | Germany |
SO52013_2 | Germany | Germany | Germany |
SO52014_1 | Australia | Australia | Australia |
SO52014_2 | Australia | Australia | Australia |
SO52015_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52015_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52016_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52016_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52017_1 | France | France | France |
SO52017_2 | France | France | France |
SO52017_3 | France | France | France |
SO52017_4 | France | France | France |
SO52018_1 | Australia | Australia | Australia |
SO52019_1 | Australia | Australia | Australia |
SO52019_2 | Australia | Australia | Australia |
SO52019_3 | Australia | Australia | Australia |
SO52020_1 | United Kingdom | United Kingdom | United Kingdom |
SO52020_2 | United Kingdom | United Kingdom | United Kingdom |
SO52021_1 | Germany | Germany | Germany |
SO52021_2 | Germany | Germany | Germany |
SO52021_3 | Germany | Germany | Germany |
SO52022_1 | United Kingdom | United Kingdom | United Kingdom |
SO52022_2 | United Kingdom | United Kingdom | United Kingdom |
SO52023_1 | Canada | Canada | Canada |
SO52024_1 | Australia | Australia | Australia |
SO52056_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52056_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52057_1 | Canada | Canada | Canada |
SO52057_2 | Canada | Canada | Canada |
SO52057_3 | Canada | Canada | Canada |
SO52058_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_3 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-07-08 22:36:54.228 UTC