[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6105 > < TAKE 125 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
125 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51411_4 | United Kingdom | United Kingdom | United Kingdom |
SO51411_5 | United Kingdom | United Kingdom | United Kingdom |
SO51412_1 | France | France | France |
SO51412_2 | France | France | France |
SO51412_3 | France | France | France |
SO51413_1 | Canada | Canada | Canada |
SO51413_2 | Canada | Canada | Canada |
SO51414_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51414_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51414_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51415_1 | Canada | Canada | Canada |
SO51415_2 | Canada | Canada | Canada |
SO51415_3 | Canada | Canada | Canada |
SO51415_4 | Canada | Canada | Canada |
SO51416_1 | United Kingdom | United Kingdom | United Kingdom |
SO51416_2 | United Kingdom | United Kingdom | United Kingdom |
SO51417_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51417_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51417_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51417_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51418_1 | Australia | Australia | Australia |
SO51418_2 | Australia | Australia | Australia |
SO51418_3 | Australia | Australia | Australia |
SO51418_4 | Australia | Australia | Australia |
SO51419_1 | Australia | Australia | Australia |
SO51419_2 | Australia | Australia | Australia |
SO51419_3 | Australia | Australia | Australia |
SO51420_1 | Australia | Australia | Australia |
SO51420_2 | Australia | Australia | Australia |
SO51420_3 | Australia | Australia | Australia |
SO51420_4 | Australia | Australia | Australia |
SO51420_5 | Australia | Australia | Australia |
SO51489_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51491_1 | Australia | Australia | Australia |
SO51424_1 | Canada | Canada | Canada |
SO51424_2 | Canada | Canada | Canada |
SO51424_3 | Canada | Canada | Canada |
SO51425_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51425_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51426_1 | Australia | Australia | Australia |
SO51426_2 | Australia | Australia | Australia |
SO51427_1 | United Kingdom | United Kingdom | United Kingdom |
SO51427_2 | United Kingdom | United Kingdom | United Kingdom |
SO51427_3 | United Kingdom | United Kingdom | United Kingdom |
SO51428_1 | France | France | France |
SO51428_2 | France | France | France |
SO51428_3 | France | France | France |
SO51429_1 | Canada | Canada | Canada |
SO51429_2 | Canada | Canada | Canada |
SO51430_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51430_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51430_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51431_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51431_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51431_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51431_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51431_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51432_1 | Australia | Australia | Australia |
SO51432_2 | Australia | Australia | Australia |
SO51433_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51433_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51434_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51435_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51435_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51435_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51435_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51436_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51436_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51437_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51437_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51437_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51437_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51437_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51438_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51438_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51439_1 | France | France | France |
SO51439_2 | France | France | France |
SO51439_3 | France | France | France |
SO51439_4 | France | France | France |
SO51440_1 | Australia | Australia | Australia |
SO51441_1 | France | France | France |
SO51441_2 | France | France | France |
SO51442_1 | United Kingdom | United Kingdom | United Kingdom |
SO51442_2 | United Kingdom | United Kingdom | United Kingdom |
SO51442_3 | United Kingdom | United Kingdom | United Kingdom |
SO51442_4 | United Kingdom | United Kingdom | United Kingdom |
SO51443_1 | Canada | Canada | Canada |
SO51443_2 | Canada | Canada | Canada |
SO51443_3 | Canada | Canada | Canada |
SO51444_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51511_3 | Australia | Australia | Australia |
SO51512_1 | France | France | France |
SO51512_2 | France | France | France |
SO51512_3 | France | France | France |
SO51512_4 | France | France | France |
SO51512_5 | France | France | France |
SO51513_1 | France | France | France |
SO51513_2 | France | France | France |
SO51447_2 | Australia | Australia | Australia |
SO51447_3 | Australia | Australia | Australia |
SO51448_1 | Australia | Australia | Australia |
SO51448_2 | Australia | Australia | Australia |
SO51448_3 | Australia | Australia | Australia |
SO51449_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51449_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51450_1 | Australia | Australia | Australia |
SO51450_2 | Australia | Australia | Australia |
SO51451_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51452_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51452_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51452_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51453_1 | United Kingdom | United Kingdom | United Kingdom |
SO51453_2 | United Kingdom | United Kingdom | United Kingdom |
SO51453_3 | United Kingdom | United Kingdom | United Kingdom |
SO51453_4 | United Kingdom | United Kingdom | United Kingdom |
SO51454_1 | Germany | Germany | Germany |
SO51454_2 | Germany | Germany | Germany |
SO51454_3 | Germany | Germany | Germany |
SO51454_4 | Germany | Germany | Germany |
Generated 2025-07-07 18:41:01.785 UTC