[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 |
---|---|---|---|
SO51212_5 | Australia | Australia | Australia |
SO51260_3 | Germany | Germany | Germany |
SO51420_4 | Australia | Australia | Australia |
SO51353_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51213_1 | Australia | Australia | Australia |
SO51261_1 | United Kingdom | United Kingdom | United Kingdom |
SO51420_5 | Australia | Australia | Australia |
SO51354_1 | Australia | Australia | Australia |
SO51489_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51469_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51421_1 | Australia | Australia | Australia |
SO51444_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51469_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51422_1 | Australia | Australia | Australia |
SO51444_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51469_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51422_2 | Australia | Australia | Australia |
SO51445_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51469_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51422_3 | Australia | Australia | Australia |
SO51445_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51469_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51423_1 | Canada | Canada | Canada |
SO51445_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51490_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51470_1 | Australia | Australia | Australia |
SO51423_2 | Canada | Canada | Canada |
SO51446_1 | Australia | Australia | Australia |
SO51490_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51470_2 | Australia | Australia | Australia |
SO51423_3 | Canada | Canada | Canada |
SO51446_2 | Australia | Australia | Australia |
SO51491_1 | Australia | Australia | Australia |
SO51471_1 | Australia | Australia | Australia |
SO51423_4 | Canada | Canada | Canada |
SO51447_1 | Australia | Australia | Australia |
SO51492_1 | Australia | Australia | Australia |
SO51424_1 | Canada | Canada | Canada |
SO51447_2 | Australia | Australia | Australia |
SO51492_2 | Australia | Australia | Australia |
SO51424_2 | Canada | Canada | Canada |
SO51447_3 | Australia | Australia | Australia |
SO51493_1 | Australia | Australia | Australia |
SO51424_3 | Canada | Canada | Canada |
SO51448_1 | Australia | Australia | Australia |
SO51493_2 | Australia | Australia | Australia |
SO51425_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51448_2 | Australia | Australia | Australia |
SO51493_3 | Australia | Australia | Australia |
SO51425_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51448_3 | Australia | Australia | Australia |
SO51493_4 | Australia | Australia | Australia |
SO51426_1 | Australia | Australia | Australia |
SO51449_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51493_5 | Australia | Australia | Australia |
SO51426_2 | Australia | Australia | Australia |
SO51449_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51493_6 | Australia | Australia | Australia |
SO51427_1 | United Kingdom | United Kingdom | United Kingdom |
SO51450_1 | Australia | Australia | Australia |
SO51494_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51427_2 | United Kingdom | United Kingdom | United Kingdom |
SO51450_2 | Australia | Australia | Australia |
SO51494_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51427_3 | United Kingdom | United Kingdom | United Kingdom |
SO51451_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51495_1 | Canada | Canada | Canada |
SO51428_1 | France | France | France |
SO51452_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51495_2 | Canada | Canada | Canada |
SO51428_2 | France | France | France |
SO51452_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51495_3 | Canada | Canada | Canada |
SO51428_3 | France | France | France |
SO51452_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51496_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51429_1 | Canada | Canada | Canada |
SO51453_1 | United Kingdom | United Kingdom | United Kingdom |
SO51496_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51429_2 | Canada | Canada | Canada |
SO51453_2 | United Kingdom | United Kingdom | United Kingdom |
SO51497_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51430_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_3 | United Kingdom | United Kingdom | United Kingdom |
SO51497_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51430_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_4 | United Kingdom | United Kingdom | United Kingdom |
SO51497_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51430_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51454_1 | Germany | Germany | Germany |
SO51497_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51431_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51454_2 | Germany | Germany | Germany |
SO51498_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51431_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51454_3 | Germany | Germany | Germany |
SO51498_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51431_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51454_4 | Germany | Germany | Germany |
SO51499_1 | United Kingdom | United Kingdom | United Kingdom |
SO51431_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51455_1 | Germany | Germany | Germany |
SO51499_2 | United Kingdom | United Kingdom | United Kingdom |
SO51431_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51455_2 | Germany | Germany | Germany |
SO51500_1 | France | France | France |
SO51432_1 | Australia | Australia | Australia |
SO51456_1 | United Kingdom | United Kingdom | United Kingdom |
SO51500_2 | France | France | France |
SO51432_2 | Australia | Australia | Australia |
SO51456_2 | United Kingdom | United Kingdom | United Kingdom |
SO51500_3 | France | France | France |
SO51433_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51457_1 | United Kingdom | United Kingdom | United Kingdom |
SO51500_4 | France | France | France |
SO51433_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51457_2 | United Kingdom | United Kingdom | United Kingdom |
SO51501_1 | Germany | Germany | Germany |
SO51434_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51458_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51501_2 | Germany | Germany | Germany |
Generated 2025-07-07 21:21:23.181 UTC