[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7742 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52245_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52245_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52246_1 | France | France | France |
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 |
SO52339_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52340_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52340_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52340_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52341_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52341_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52341_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52320_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52320_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52323_1 | Australia | Australia | Australia |
SO52323_2 | Australia | Australia | Australia |
SO52324_1 | Australia | Australia | Australia |
SO52324_2 | Australia | Australia | Australia |
SO52324_3 | Australia | Australia | Australia |
SO52324_4 | Australia | Australia | Australia |
SO52325_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52325_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52326_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52326_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52327_1 | France | France | France |
SO52327_2 | France | France | France |
SO52327_3 | France | France | France |
SO52327_4 | France | France | France |
SO52328_1 | Australia | Australia | Australia |
SO52328_2 | Australia | Australia | Australia |
SO52329_1 | France | France | France |
SO52329_2 | France | France | France |
SO52329_3 | France | France | France |
SO52330_1 | Australia | Australia | Australia |
SO52330_2 | Australia | Australia | Australia |
SO52331_1 | Australia | Australia | Australia |
SO52331_2 | Australia | Australia | Australia |
SO52332_1 | Australia | Australia | Australia |
SO52332_2 | Australia | Australia | Australia |
SO52333_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52334_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52334_2 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-07-21 15:12:46.338 UTC