[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8037 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52440_2 | France | France | France |
SO52441_1 | France | France | France |
SO52442_1 | Germany | Germany | Germany |
SO52443_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_3 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO52470_4 | United Kingdom | United Kingdom | United Kingdom |
SO52471_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52471_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52471_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52472_1 | Canada | Canada | Canada |
SO52472_2 | Canada | Canada | Canada |
SO52473_1 | Canada | Canada | Canada |
SO52474_1 | Australia | Australia | Australia |
SO52451_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52452_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52452_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52452_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52452_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52453_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52453_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52454_1 | United Kingdom | United Kingdom | United Kingdom |
SO52454_2 | United Kingdom | United Kingdom | United Kingdom |
SO52454_3 | United Kingdom | United Kingdom | United Kingdom |
SO52454_4 | United Kingdom | United Kingdom | United Kingdom |
SO52455_1 | Germany | Germany | Germany |
SO52455_2 | Germany | Germany | Germany |
SO52456_1 | Australia | Australia | Australia |
SO52456_2 | Australia | Australia | Australia |
SO52457_1 | Australia | Australia | Australia |
SO52457_2 | Australia | Australia | Australia |
SO52457_3 | Australia | Australia | Australia |
SO52458_1 | Australia | Australia | Australia |
SO52458_2 | Australia | Australia | Australia |
SO52458_3 | Australia | Australia | Australia |
SO52458_4 | Australia | Australia | Australia |
SO52459_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52459_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52460_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52460_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52460_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52461_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52461_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52461_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52462_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52462_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52462_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52463_1 | United Kingdom | United Kingdom | United Kingdom |
SO52463_2 | United Kingdom | United Kingdom | United Kingdom |
SO52463_3 | United Kingdom | United Kingdom | United Kingdom |
SO52463_4 | United Kingdom | United Kingdom | United Kingdom |
SO52464_1 | Germany | Germany | Germany |
SO52464_2 | Germany | Germany | Germany |
SO52465_1 | Germany | Germany | Germany |
SO52465_2 | Germany | Germany | Germany |
SO52465_3 | Germany | Germany | Germany |
SO52466_1 | United Kingdom | United Kingdom | United Kingdom |
SO52467_1 | Germany | Germany | Germany |
SO52468_1 | Australia | Australia | Australia |
SO52468_2 | Australia | Australia | Australia |
SO52468_3 | Australia | Australia | Australia |
SO52468_4 | Australia | Australia | Australia |
SO52469_1 | France | France | France |
SO52469_2 | France | France | France |
SO52469_3 | France | France | France |
SO52469_4 | France | France | France |
SO52469_5 | France | France | France |
SO52470_1 | United Kingdom | United Kingdom | United Kingdom |
SO52470_2 | United Kingdom | United Kingdom | United Kingdom |
SO52470_3 | United Kingdom | United Kingdom | United Kingdom |
SO52500_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52501_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52501_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52502_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52502_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52502_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52502_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52503_1 | United Kingdom | United Kingdom | United Kingdom |
SO52246_2 | France | France | France |
SO52246_3 | France | France | France |
SO52247_1 | France | France | France |
SO52248_1 | France | France | France |
SO52248_2 | France | France | France |
SO52248_3 | France | France | France |
SO52248_4 | France | France | France |
SO52248_5 | France | France | France |
SO52249_1 | Canada | Canada | Canada |
SO52249_2 | Canada | Canada | Canada |
SO52250_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52250_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52251_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52251_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52252_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_2 | United Kingdom | United Kingdom | United Kingdom |
SO52253_3 | United Kingdom | United Kingdom | United Kingdom |
SO52254_1 | United Kingdom | United Kingdom | United Kingdom |
SO52254_2 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-07 21:27:15.218 UTC