[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6127 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51465_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51466_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51466_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51466_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51467_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51467_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51467_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51467_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51468_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51468_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51479_4 | Australia | Australia | Australia |
SO51480_1 | France | France | France |
SO51480_2 | France | France | France |
SO51480_3 | France | France | France |
SO51481_1 | United Kingdom | United Kingdom | United Kingdom |
SO51481_2 | United Kingdom | United Kingdom | United Kingdom |
SO51482_1 | Germany | Germany | Germany |
SO51482_2 | Germany | Germany | Germany |
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 |
SO51500_2 | France | France | France |
SO51500_3 | France | France | France |
SO51500_4 | France | France | France |
SO51501_1 | Germany | Germany | Germany |
SO51501_2 | Germany | Germany | Germany |
SO51502_1 | France | France | France |
SO51502_2 | France | France | France |
SO51502_3 | France | France | France |
SO51502_4 | France | France | France |
SO51502_5 | France | France | France |
SO51503_1 | France | France | France |
SO51503_2 | France | France | France |
SO51504_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51504_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51505_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51505_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51506_1 | United Kingdom | United Kingdom | United Kingdom |
SO51506_2 | United Kingdom | United Kingdom | United Kingdom |
SO51506_3 | United Kingdom | United Kingdom | United Kingdom |
SO51506_4 | United Kingdom | United Kingdom | United Kingdom |
SO51507_1 | Australia | Australia | Australia |
SO51507_2 | Australia | Australia | Australia |
SO51508_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51508_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51509_1 | Germany | Germany | Germany |
SO51509_2 | Germany | Germany | Germany |
SO51509_3 | Germany | Germany | Germany |
SO51509_4 | Germany | Germany | Germany |
SO51510_1 | United Kingdom | United Kingdom | United Kingdom |
SO51510_2 | United Kingdom | United Kingdom | United Kingdom |
SO51511_1 | Australia | Australia | Australia |
SO51511_2 | Australia | Australia | Australia |
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 |
Generated 2025-07-13 02:25:46.845 UTC