[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7757 > < TAKE 124 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
124 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52274_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52274_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52276_1 | France | France | France |
SO52276_2 | France | France | France |
SO52276_3 | France | France | France |
SO52276_4 | France | France | France |
SO52276_5 | France | France | France |
SO52277_1 | France | France | France |
SO52277_2 | France | France | France |
SO52277_3 | France | France | France |
SO52277_4 | France | France | France |
SO52278_1 | Australia | Australia | Australia |
SO52278_2 | Australia | Australia | Australia |
SO52278_3 | Australia | Australia | Australia |
SO52278_4 | Australia | Australia | Australia |
SO52279_1 | Australia | Australia | Australia |
SO52279_2 | Australia | Australia | Australia |
SO52279_3 | Australia | Australia | Australia |
SO52279_4 | Australia | Australia | Australia |
SO52280_1 | Australia | Australia | Australia |
SO52280_2 | Australia | Australia | Australia |
SO52280_3 | Australia | Australia | Australia |
SO52280_4 | Australia | Australia | Australia |
SO52281_1 | Australia | Australia | Australia |
SO52281_2 | Australia | Australia | Australia |
SO52281_3 | Australia | Australia | Australia |
SO52281_4 | Australia | Australia | Australia |
SO52282_1 | United Kingdom | United Kingdom | United Kingdom |
SO52282_2 | United Kingdom | United Kingdom | United Kingdom |
SO52283_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52284_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52285_1 | Australia | Australia | Australia |
SO52285_2 | Australia | Australia | Australia |
SO52285_3 | Australia | Australia | Australia |
SO52286_1 | Australia | Australia | Australia |
SO52286_2 | Australia | Australia | Australia |
SO52286_3 | Australia | Australia | Australia |
SO52286_4 | Australia | Australia | Australia |
SO52286_5 | Australia | Australia | Australia |
SO52287_1 | Australia | Australia | Australia |
SO52287_2 | Australia | Australia | Australia |
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 |
SO52144_2 | Canada | Canada | Canada |
SO52144_3 | Canada | Canada | Canada |
SO52145_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52145_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52145_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52146_1 | Canada | Canada | Canada |
SO52146_2 | Canada | Canada | Canada |
SO52147_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52147_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52147_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52147_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52148_1 | Australia | Australia | Australia |
SO52148_2 | Australia | Australia | Australia |
SO52149_1 | Australia | Australia | Australia |
SO52149_2 | Australia | Australia | Australia |
SO52150_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52150_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52150_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52151_1 | United Kingdom | United Kingdom | United Kingdom |
SO52152_1 | United Kingdom | United Kingdom | United Kingdom |
SO52152_2 | United Kingdom | United Kingdom | United Kingdom |
SO52152_3 | United Kingdom | United Kingdom | United Kingdom |
SO52153_1 | Australia | Australia | Australia |
SO52154_1 | Australia | Australia | Australia |
SO52154_2 | Australia | Australia | Australia |
SO52154_3 | Australia | Australia | Australia |
SO52155_1 | Australia | Australia | Australia |
SO52156_1 | Australia | Australia | Australia |
SO52156_2 | Australia | Australia | Australia |
SO52156_3 | Australia | Australia | Australia |
SO52156_4 | Australia | Australia | Australia |
SO52157_1 | Australia | Australia | Australia |
SO52158_1 | Australia | Australia | Australia |
SO52158_2 | Australia | Australia | Australia |
SO52158_3 | Australia | Australia | Australia |
SO52159_1 | Australia | Australia | Australia |
SO52159_2 | Australia | Australia | Australia |
SO52159_3 | Australia | Australia | Australia |
SO52159_4 | Australia | Australia | Australia |
SO52159_5 | Australia | Australia | Australia |
SO52160_1 | United Kingdom | United Kingdom | United Kingdom |
SO52160_2 | United Kingdom | United Kingdom | United Kingdom |
SO52160_3 | United Kingdom | United Kingdom | United Kingdom |
SO52161_1 | United Kingdom | United Kingdom | United Kingdom |
SO52161_2 | United Kingdom | United Kingdom | United Kingdom |
SO52162_1 | Germany | Germany | Germany |
SO52162_2 | Germany | Germany | Germany |
SO52162_3 | Germany | Germany | Germany |
SO52162_4 | Germany | Germany | Germany |
SO52162_5 | Germany | Germany | Germany |
SO52163_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52164_1 | Australia | Australia | Australia |
SO52164_2 | Australia | Australia | Australia |
SO52164_3 | Australia | Australia | Australia |
SO52165_1 | Australia | Australia | Australia |
SO52165_2 | Australia | Australia | Australia |
SO52393_2 | United Kingdom | United Kingdom | United Kingdom |
SO52394_1 | United Kingdom | United Kingdom | United Kingdom |
SO52394_2 | United Kingdom | United Kingdom | United Kingdom |
SO52395_1 | France | France | France |
SO52396_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_4 | 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 |
Generated 2025-07-09 11:40:02.746 UTC