[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5586 > < TAKE 120 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
120 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51223_1 | Germany | Germany | Germany |
SO51247_3 | Germany | Germany | Germany |
SO50898_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51269_3 | Australia | Australia | Australia |
SO51223_2 | Germany | Germany | Germany |
SO51248_1 | France | France | France |
SO50899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51269_4 | Australia | Australia | Australia |
SO51223_3 | Germany | Germany | Germany |
SO51249_1 | United Kingdom | United Kingdom | United Kingdom |
SO50900_1 | Australia | Australia | Australia |
SO51270_1 | United Kingdom | United Kingdom | United Kingdom |
SO51223_4 | Germany | Germany | Germany |
SO51249_2 | United Kingdom | United Kingdom | United Kingdom |
SO50901_1 | Australia | Australia | Australia |
SO51270_2 | United Kingdom | United Kingdom | United Kingdom |
SO51224_1 | France | France | France |
SO51249_3 | United Kingdom | United Kingdom | United Kingdom |
SO50902_1 | Australia | Australia | Australia |
SO51270_3 | United Kingdom | United Kingdom | United Kingdom |
SO51224_2 | France | France | France |
SO51250_1 | United Kingdom | United Kingdom | United Kingdom |
SO50903_1 | Australia | Australia | Australia |
SO51271_1 | Germany | Germany | Germany |
SO51225_1 | United Kingdom | United Kingdom | United Kingdom |
SO51250_2 | United Kingdom | United Kingdom | United Kingdom |
SO50904_1 | Australia | Australia | Australia |
SO51271_2 | Germany | Germany | Germany |
SO51225_2 | United Kingdom | United Kingdom | United Kingdom |
SO51250_3 | United Kingdom | United Kingdom | United Kingdom |
SO50905_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51271_3 | Germany | Germany | Germany |
SO51225_3 | United Kingdom | United Kingdom | United Kingdom |
SO51250_4 | United Kingdom | United Kingdom | United Kingdom |
SO50906_1 | Germany | Germany | Germany |
SO51271_4 | Germany | Germany | Germany |
SO51226_1 | United Kingdom | United Kingdom | United Kingdom |
SO51251_1 | France | France | France |
SO50907_1 | France | France | France |
SO51272_1 | United Kingdom | United Kingdom | United Kingdom |
SO51226_2 | United Kingdom | United Kingdom | United Kingdom |
SO51252_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50908_1 | United Kingdom | United Kingdom | United Kingdom |
SO51272_2 | United Kingdom | United Kingdom | United Kingdom |
SO51227_1 | Germany | Germany | Germany |
SO51252_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50909_1 | United Kingdom | United Kingdom | United Kingdom |
SO51273_1 | United Kingdom | United Kingdom | United Kingdom |
SO51227_2 | Germany | Germany | Germany |
SO51252_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50910_1 | Germany | Germany | Germany |
SO51273_2 | United Kingdom | United Kingdom | United Kingdom |
SO51227_3 | Germany | Germany | Germany |
SO51253_1 | Canada | Canada | Canada |
SO50911_1 | Germany | Germany | Germany |
SO51274_1 | Germany | Germany | Germany |
SO51228_1 | France | France | France |
SO51253_2 | Canada | Canada | Canada |
SO50912_1 | Australia | Australia | Australia |
SO51274_2 | Germany | Germany | Germany |
SO51228_2 | France | France | France |
SO51254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50913_1 | Australia | Australia | Australia |
SO51274_3 | Germany | Germany | Germany |
SO51228_3 | France | France | France |
SO51254_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50914_1 | Australia | Australia | Australia |
SO51275_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51228_4 | France | France | France |
SO51254_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50915_1 | Australia | Australia | Australia |
SO51275_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51228_5 | France | France | France |
SO51254_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50916_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51275_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51229_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51255_1 | Australia | Australia | Australia |
SO50917_1 | France | France | France |
SO51276_1 | Canada | Canada | Canada |
SO51230_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51255_2 | Australia | Australia | Australia |
SO50918_1 | France | France | France |
SO51276_2 | Canada | Canada | Canada |
SO51230_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51255_3 | Australia | Australia | Australia |
SO50919_1 | Germany | Germany | Germany |
SO51276_3 | Canada | Canada | Canada |
SO51230_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51256_1 | Australia | Australia | Australia |
SO50920_1 | France | France | France |
SO51277_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51230_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51256_2 | Australia | Australia | Australia |
SO50921_1 | United Kingdom | United Kingdom | United Kingdom |
SO51277_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51231_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51257_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50922_1 | Germany | Germany | Germany |
SO51278_1 | Germany | Germany | Germany |
SO51231_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51258_1 | Canada | Canada | Canada |
SO50923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51278_2 | Germany | Germany | Germany |
SO51232_1 | United Kingdom | United Kingdom | United Kingdom |
SO51258_2 | Canada | Canada | Canada |
SO50924_1 | Australia | Australia | Australia |
SO51278_3 | Germany | Germany | Germany |
SO51232_2 | United Kingdom | United Kingdom | United Kingdom |
SO51259_1 | France | France | France |
SO50925_1 | Australia | Australia | Australia |
SO51279_1 | Germany | Germany | Germany |
SO51233_1 | Australia | Australia | Australia |
SO51259_2 | France | France | France |
SO50926_1 | Australia | Australia | Australia |
SO51279_2 | Germany | Germany | Germany |
SO51234_1 | Australia | Australia | Australia |
SO51259_3 | France | France | France |
SO50927_1 | Australia | Australia | Australia |
SO51280_1 | Australia | Australia | Australia |
Generated 2025-07-09 11:19:02.314 UTC