[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8176 > < TAKE 120 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
120 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52416_1 | United Kingdom | United Kingdom | United Kingdom |
SO52416_2 | United Kingdom | United Kingdom | United Kingdom |
SO52416_3 | United Kingdom | United Kingdom | United Kingdom |
SO52417_1 | Australia | Australia | Australia |
SO52418_1 | United Kingdom | United Kingdom | United Kingdom |
SO52418_2 | United Kingdom | United Kingdom | United Kingdom |
SO52418_3 | United Kingdom | United Kingdom | United Kingdom |
SO52418_4 | United Kingdom | United Kingdom | United Kingdom |
SO52419_1 | Canada | Canada | Canada |
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 |
SO52423_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52427_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52428_1 | Canada | Canada | Canada |
SO52428_2 | Canada | Canada | Canada |
SO52428_3 | Canada | Canada | Canada |
SO52429_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52429_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52430_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52430_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52430_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52431_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52433_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52433_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52434_1 | Canada | Canada | Canada |
SO52434_2 | Canada | Canada | Canada |
SO52434_3 | Canada | Canada | Canada |
SO52435_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52435_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52436_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52436_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52437_1 | United Kingdom | United Kingdom | United Kingdom |
SO52437_2 | United Kingdom | United Kingdom | United Kingdom |
SO52437_3 | United Kingdom | United Kingdom | United Kingdom |
SO52438_1 | Germany | Germany | Germany |
SO52439_1 | Germany | Germany | Germany |
SO52439_2 | Germany | Germany | Germany |
SO52440_1 | France | France | France |
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 |
SO52523_1 | United Kingdom | United Kingdom | United Kingdom |
SO52523_2 | United Kingdom | United Kingdom | United Kingdom |
SO52523_3 | United Kingdom | United Kingdom | United Kingdom |
SO52524_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52525_1 | Australia | Australia | Australia |
SO52525_2 | Australia | Australia | Australia |
SO52526_1 | Australia | Australia | Australia |
SO52526_2 | 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 |
Generated 2025-07-09 15:16:24.343 UTC