[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8606 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52665_1 | Germany | Germany | Germany |
SO52613_2 | United Kingdom | United Kingdom | United Kingdom |
SO52665_2 | Germany | Germany | Germany |
SO52613_3 | United Kingdom | United Kingdom | United Kingdom |
SO52666_1 | Germany | Germany | Germany |
SO52613_4 | United Kingdom | United Kingdom | United Kingdom |
SO52666_2 | Germany | Germany | Germany |
SO52614_1 | France | France | France |
SO52666_3 | Germany | Germany | Germany |
SO52614_2 | France | France | France |
SO52667_1 | United Kingdom | United Kingdom | United Kingdom |
SO52614_3 | France | France | France |
SO52667_2 | United Kingdom | United Kingdom | United Kingdom |
SO52615_1 | France | France | France |
SO52668_1 | United Kingdom | United Kingdom | United Kingdom |
SO52615_2 | France | France | France |
SO52668_2 | United Kingdom | United Kingdom | United Kingdom |
SO52616_1 | United Kingdom | United Kingdom | United Kingdom |
SO52668_3 | United Kingdom | United Kingdom | United Kingdom |
SO52616_2 | United Kingdom | United Kingdom | United Kingdom |
SO52669_1 | United Kingdom | United Kingdom | United Kingdom |
SO52616_3 | United Kingdom | United Kingdom | United Kingdom |
SO52669_2 | United Kingdom | United Kingdom | United Kingdom |
SO52616_4 | United Kingdom | United Kingdom | United Kingdom |
SO52669_3 | United Kingdom | United Kingdom | United Kingdom |
SO52617_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52669_4 | United Kingdom | United Kingdom | United Kingdom |
SO52617_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52670_1 | Australia | Australia | Australia |
SO52617_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52670_2 | Australia | Australia | Australia |
SO52618_1 | Australia | Australia | Australia |
SO52671_1 | France | France | France |
SO52618_2 | Australia | Australia | Australia |
SO52671_2 | France | France | France |
SO52618_3 | Australia | Australia | Australia |
SO52671_3 | France | France | France |
SO52619_1 | Australia | Australia | Australia |
SO52671_4 | France | France | France |
SO52619_2 | Australia | Australia | Australia |
SO52671_5 | France | France | France |
SO52620_1 | Australia | Australia | Australia |
SO52672_1 | Australia | Australia | Australia |
SO52620_2 | Australia | Australia | Australia |
SO52672_2 | Australia | Australia | Australia |
SO52620_3 | Australia | Australia | Australia |
SO52673_1 | Australia | Australia | Australia |
SO52621_1 | Australia | Australia | Australia |
SO52673_2 | Australia | Australia | Australia |
SO52622_1 | Australia | Australia | Australia |
SO52674_1 | Australia | Australia | Australia |
SO52623_1 | Australia | Australia | Australia |
SO52674_2 | Australia | Australia | Australia |
SO52624_1 | Australia | Australia | Australia |
SO52674_3 | Australia | Australia | Australia |
SO52625_1 | France | France | France |
SO52675_1 | Australia | Australia | Australia |
SO52626_1 | Canada | Canada | Canada |
SO52676_1 | Australia | Australia | Australia |
SO52626_2 | Canada | Canada | Canada |
SO52677_1 | Australia | Australia | Australia |
SO52626_3 | Canada | Canada | Canada |
SO52677_2 | Australia | Australia | Australia |
SO52627_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52677_3 | Australia | Australia | Australia |
SO52627_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52678_1 | Germany | Germany | Germany |
SO52627_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52678_2 | Germany | Germany | Germany |
SO52628_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52679_1 | United Kingdom | United Kingdom | United Kingdom |
SO52628_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52679_2 | United Kingdom | United Kingdom | United Kingdom |
SO52628_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52679_3 | United Kingdom | United Kingdom | United Kingdom |
SO52629_1 | Canada | Canada | Canada |
SO52680_1 | United Kingdom | United Kingdom | United Kingdom |
SO52629_2 | Canada | Canada | Canada |
SO52680_2 | United Kingdom | United Kingdom | United Kingdom |
SO52630_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52681_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52630_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52681_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52714_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52682_1 | Canada | Canada | Canada |
SO52715_1 | Canada | Canada | Canada |
SO52683_1 | Canada | Canada | Canada |
SO52715_2 | Canada | Canada | Canada |
SO52683_2 | Canada | Canada | Canada |
SO52715_3 | Canada | Canada | Canada |
SO52684_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52716_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52684_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52716_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52685_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52717_1 | Australia | Australia | Australia |
SO52685_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52717_2 | Australia | Australia | Australia |
SO52686_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52686_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52686_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52687_1 | Canada | Canada | Canada |
SO52687_2 | Canada | Canada | Canada |
SO52687_3 | Canada | Canada | Canada |
SO52688_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52689_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52689_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52689_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52690_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52690_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52691_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52691_2 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-07-16 16:12:51.485 UTC