[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8747 > < TAKE 60 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
60 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52660_3 | Australia | Australia | Australia |
SO52661_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52661_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52662_1 | Canada | Canada | Canada |
SO52662_2 | Canada | Canada | Canada |
SO52663_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52663_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52663_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52663_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52664_1 | Canada | Canada | Canada |
SO52664_2 | Canada | Canada | Canada |
SO52664_3 | Canada | Canada | Canada |
SO52665_1 | Germany | Germany | Germany |
SO52665_2 | Germany | Germany | Germany |
SO52666_1 | Germany | Germany | Germany |
SO52666_2 | Germany | Germany | Germany |
SO52666_3 | Germany | Germany | Germany |
SO52667_1 | United Kingdom | United Kingdom | United Kingdom |
SO52667_2 | United Kingdom | United Kingdom | United Kingdom |
SO52668_1 | United Kingdom | United Kingdom | United Kingdom |
SO52668_2 | United Kingdom | United Kingdom | United Kingdom |
SO52668_3 | United Kingdom | United Kingdom | United Kingdom |
SO52669_1 | United Kingdom | United Kingdom | United Kingdom |
SO52669_2 | United Kingdom | United Kingdom | United Kingdom |
SO52669_3 | United Kingdom | United Kingdom | United Kingdom |
SO52669_4 | United Kingdom | United Kingdom | United Kingdom |
SO52670_1 | Australia | Australia | Australia |
SO52670_2 | Australia | Australia | Australia |
SO52671_1 | France | France | France |
SO52671_2 | France | France | France |
SO52671_3 | France | France | France |
SO52671_4 | France | France | France |
SO52671_5 | France | France | France |
SO52672_1 | Australia | Australia | Australia |
SO52672_2 | Australia | Australia | Australia |
SO52673_1 | Australia | Australia | Australia |
SO52673_2 | Australia | Australia | Australia |
SO52674_1 | Australia | Australia | Australia |
SO52674_2 | Australia | Australia | Australia |
SO52674_3 | Australia | Australia | Australia |
SO52675_1 | Australia | Australia | Australia |
SO52676_1 | Australia | Australia | Australia |
SO52677_1 | Australia | Australia | Australia |
SO52677_2 | Australia | Australia | Australia |
SO52677_3 | Australia | Australia | Australia |
SO52678_1 | Germany | Germany | Germany |
SO52678_2 | Germany | Germany | Germany |
SO52679_1 | United Kingdom | United Kingdom | United Kingdom |
SO52679_2 | United Kingdom | United Kingdom | United Kingdom |
SO52679_3 | United Kingdom | United Kingdom | United Kingdom |
SO52680_1 | United Kingdom | United Kingdom | United Kingdom |
SO52680_2 | United Kingdom | United Kingdom | United Kingdom |
SO52681_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52681_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52682_1 | Canada | Canada | Canada |
SO52683_1 | Canada | Canada | Canada |
SO52683_2 | Canada | Canada | Canada |
SO52684_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52684_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52685_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-07 19:24:38.429 UTC