[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6750 > < TAKE 250 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
250 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51389_3 | Germany | Germany | Germany |
SO51390_1 | United Kingdom | United Kingdom | United Kingdom |
SO51390_2 | United Kingdom | United Kingdom | United Kingdom |
SO51391_1 | United Kingdom | United Kingdom | United Kingdom |
SO51391_2 | United Kingdom | United Kingdom | United Kingdom |
SO51391_3 | United Kingdom | United Kingdom | United Kingdom |
SO51392_1 | France | France | France |
SO51392_2 | France | France | France |
SO51392_3 | France | France | France |
SO51392_4 | France | France | France |
SO51393_1 | France | France | France |
SO51393_2 | France | France | France |
SO51394_1 | United Kingdom | United Kingdom | United Kingdom |
SO51394_2 | United Kingdom | United Kingdom | United Kingdom |
SO51395_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51396_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51396_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51396_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51397_1 | Canada | Canada | Canada |
SO51397_2 | Canada | Canada | Canada |
SO51397_3 | Canada | Canada | Canada |
SO51398_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51399_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51399_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51399_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51400_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51400_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51920_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51920_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51921_1 | France | France | France |
SO51921_2 | France | France | France |
SO51922_1 | Australia | Australia | Australia |
SO51922_2 | Australia | Australia | Australia |
SO51922_3 | Australia | Australia | Australia |
SO51923_1 | France | France | France |
SO51684_3 | Australia | Australia | Australia |
SO51684_4 | Australia | Australia | Australia |
SO51684_5 | Australia | Australia | Australia |
SO51685_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51686_1 | France | France | France |
SO51686_2 | France | France | France |
SO51687_1 | Germany | Germany | Germany |
SO51687_2 | Germany | Germany | Germany |
SO51687_3 | Germany | Germany | Germany |
SO51688_1 | France | France | France |
SO51688_2 | France | France | France |
SO51689_1 | Germany | Germany | Germany |
SO51689_2 | Germany | Germany | Germany |
SO51689_3 | Germany | Germany | Germany |
SO51876_1 | Australia | Australia | Australia |
SO51876_2 | Australia | Australia | Australia |
SO51877_1 | France | France | France |
SO51877_2 | France | France | France |
SO51877_3 | France | France | France |
SO51877_4 | France | France | France |
SO51878_1 | United Kingdom | United Kingdom | United Kingdom |
SO51879_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51880_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51880_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51880_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51881_1 | Australia | Australia | Australia |
SO51881_2 | Australia | Australia | Australia |
SO51881_3 | Australia | Australia | Australia |
SO51882_1 | Australia | Australia | Australia |
SO51882_2 | Australia | Australia | Australia |
SO51882_3 | Australia | Australia | Australia |
SO51883_1 | Australia | Australia | Australia |
SO51884_1 | Australia | Australia | Australia |
SO51884_2 | Australia | Australia | Australia |
SO51884_3 | Australia | Australia | Australia |
SO51885_1 | Australia | Australia | Australia |
SO51886_1 | Australia | Australia | Australia |
SO51887_1 | Canada | Canada | Canada |
SO51887_2 | Canada | Canada | Canada |
SO51888_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51888_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51888_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51889_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51889_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51890_1 | Canada | Canada | Canada |
SO51890_2 | Canada | Canada | Canada |
SO51891_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51891_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51892_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51892_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51893_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51894_1 | Canada | Canada | Canada |
SO51894_2 | Canada | Canada | Canada |
SO51894_3 | Canada | Canada | Canada |
SO51894_4 | Canada | Canada | Canada |
SO51895_1 | 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 |
SO51898_2 | Canada | Canada | Canada |
SO51898_3 | Canada | Canada | Canada |
SO51899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51899_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51899_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51900_1 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO51970_2 | Australia | Australia | Australia |
SO51970_3 | Australia | Australia | Australia |
SO51970_4 | Australia | Australia | Australia |
SO51971_1 | Australia | Australia | Australia |
SO51971_2 | Australia | Australia | Australia |
SO51971_3 | Australia | Australia | Australia |
SO51971_4 | Australia | Australia | Australia |
SO51971_5 | Australia | Australia | Australia |
SO51923_2 | France | France | France |
SO51923_3 | France | France | France |
SO51924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51925_1 | Canada | Canada | Canada |
SO51925_2 | Canada | Canada | Canada |
SO51926_1 | Australia | Australia | Australia |
SO51926_2 | Australia | Australia | Australia |
SO51926_3 | Australia | Australia | Australia |
SO51927_1 | Australia | Australia | Australia |
SO51927_2 | Australia | Australia | Australia |
SO51927_3 | Australia | Australia | Australia |
SO51927_4 | Australia | Australia | Australia |
SO51928_1 | Australia | Australia | Australia |
SO51928_2 | Australia | Australia | Australia |
SO51929_1 | Australia | Australia | Australia |
SO51930_1 | Australia | Australia | Australia |
SO51931_1 | Australia | Australia | Australia |
SO51932_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51933_1 | Canada | Canada | Canada |
SO51933_2 | Canada | Canada | Canada |
SO51933_3 | Canada | Canada | Canada |
SO51934_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51934_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51934_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51935_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51935_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51936_1 | Canada | Canada | Canada |
SO51936_2 | Canada | Canada | Canada |
SO51936_3 | Canada | Canada | Canada |
SO51936_4 | Canada | Canada | Canada |
SO51937_1 | Canada | Canada | Canada |
SO51937_2 | Canada | Canada | Canada |
SO51937_3 | Canada | Canada | Canada |
SO51937_4 | Canada | Canada | Canada |
SO51938_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51940_1 | Canada | Canada | Canada |
SO51940_2 | Canada | Canada | Canada |
SO51940_3 | Canada | Canada | Canada |
SO51941_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51941_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51941_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51942_1 | Canada | Canada | Canada |
SO51942_2 | Canada | Canada | Canada |
SO51943_1 | Canada | Canada | Canada |
SO51943_2 | Canada | Canada | Canada |
SO51943_3 | Canada | Canada | Canada |
SO51944_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51944_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51945_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51945_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51946_1 | Canada | Canada | Canada |
SO51946_2 | Canada | Canada | Canada |
SO51947_1 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
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 |
Generated 2025-04-06 02:08:11.429 UTC