[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7042 > < TAKE 120 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
120 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
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 |
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 |
SO51972_1 | Australia | Australia | Australia |
SO51973_1 | Australia | Australia | Australia |
SO51973_2 | Australia | Australia | Australia |
SO51973_3 | Australia | Australia | Australia |
SO51974_1 | Australia | Australia | Australia |
SO51975_1 | Australia | Australia | Australia |
SO51976_1 | Australia | Australia | Australia |
SO51976_2 | Australia | Australia | Australia |
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 |
SO51981_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51982_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51983_1 | Canada | Canada | Canada |
SO51984_1 | Canada | Canada | Canada |
SO51984_2 | Canada | Canada | Canada |
SO51985_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51985_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51986_1 | Canada | Canada | Canada |
SO51986_2 | Canada | Canada | Canada |
SO51986_3 | Canada | Canada | Canada |
SO51987_1 | Canada | Canada | Canada |
SO51988_1 | Canada | Canada | Canada |
SO51988_2 | Canada | Canada | Canada |
SO51989_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51989_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51989_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51990_1 | Canada | Canada | Canada |
SO51990_2 | Canada | Canada | Canada |
SO51990_3 | Canada | Canada | Canada |
SO51990_4 | Canada | Canada | Canada |
SO51991_1 | Canada | Canada | Canada |
SO51991_2 | Canada | Canada | Canada |
SO51992_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51992_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51993_1 | Canada | Canada | Canada |
SO51994_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51994_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51994_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51995_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51995_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51995_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51996_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51996_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51997_1 | France | France | France |
SO51997_2 | France | France | France |
SO51998_1 | United Kingdom | United Kingdom | United Kingdom |
SO51998_2 | United Kingdom | United Kingdom | United Kingdom |
SO51998_3 | United Kingdom | United Kingdom | United Kingdom |
SO51999_1 | United Kingdom | United Kingdom | United Kingdom |
SO51999_2 | United Kingdom | United Kingdom | United Kingdom |
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 |
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 |
SO52033_1 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-16 16:19:10.579 UTC