[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 |
---|---|---|---|
SO52443_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52445_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52445_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52445_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52446_1 | Canada | Canada | Canada |
SO52446_2 | Canada | Canada | Canada |
SO52446_3 | Canada | Canada | Canada |
SO52447_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52448_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52737_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52737_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52737_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52738_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52738_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52738_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52739_1 | Canada | Canada | Canada |
SO52739_2 | Canada | Canada | Canada |
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 |
SO52691_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52692_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52692_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52693_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52694_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52695_1 | Canada | Canada | Canada |
SO52695_2 | Canada | Canada | Canada |
SO52696_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52696_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52697_1 | Canada | Canada | Canada |
SO52697_2 | Canada | Canada | Canada |
SO52698_1 | United Kingdom | United Kingdom | United Kingdom |
SO52699_1 | United Kingdom | United Kingdom | United Kingdom |
SO52699_2 | United Kingdom | United Kingdom | United Kingdom |
SO52699_3 | United Kingdom | United Kingdom | United Kingdom |
SO52699_4 | United Kingdom | United Kingdom | United Kingdom |
SO52700_1 | France | France | France |
SO52700_2 | France | France | France |
SO52701_1 | France | France | France |
SO52702_1 | France | France | France |
SO52703_1 | United Kingdom | United Kingdom | United Kingdom |
SO52704_1 | France | France | France |
SO52704_2 | France | France | France |
SO52705_1 | United Kingdom | United Kingdom | United Kingdom |
SO52705_2 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-07 22:06:08.266 UTC