[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8051 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
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 |
SO52448_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52449_1 | Germany | Germany | Germany |
SO52450_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52450_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52451_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52451_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52451_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52451_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52222_3 | Germany | Germany | Germany |
SO52223_1 | United Kingdom | United Kingdom | United Kingdom |
SO52223_2 | United Kingdom | United Kingdom | United Kingdom |
SO52223_3 | United Kingdom | United Kingdom | United Kingdom |
SO52223_4 | United Kingdom | United Kingdom | United Kingdom |
SO52224_1 | United Kingdom | United Kingdom | United Kingdom |
SO52224_2 | United Kingdom | United Kingdom | United Kingdom |
SO52225_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52225_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52225_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52226_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52226_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52226_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52227_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52227_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52231_1 | Canada | Canada | Canada |
SO52232_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52233_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52233_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52236_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52236_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52236_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52237_1 | Canada | Canada | Canada |
SO52237_2 | Canada | Canada | Canada |
SO52237_3 | Canada | Canada | Canada |
SO52238_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52239_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52240_1 | Canada | Canada | Canada |
SO52240_2 | Canada | Canada | Canada |
SO52241_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52241_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52242_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52243_1 | Canada | Canada | Canada |
SO52243_2 | Canada | Canada | Canada |
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 |
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 |
Generated 2025-07-08 16:42:02.272 UTC