[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5392 > < TAKE 112 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
112 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51180_2 | Germany | Germany | Germany |
SO51180_3 | Germany | Germany | Germany |
SO51180_4 | Germany | Germany | Germany |
SO51180_5 | Germany | Germany | Germany |
SO51181_1 | France | France | France |
SO51181_2 | France | France | France |
SO51181_3 | France | France | France |
SO51181_4 | France | France | France |
SO51182_1 | Canada | Canada | Canada |
SO51182_2 | Canada | Canada | Canada |
SO51183_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51183_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51184_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51184_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51184_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51184_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51185_1 | Germany | Germany | Germany |
SO51185_2 | Germany | Germany | Germany |
SO51185_3 | Germany | Germany | Germany |
SO51186_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51187_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51187_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51188_1 | Germany | Germany | Germany |
SO51189_1 | Australia | Australia | Australia |
SO51189_2 | Australia | Australia | Australia |
SO51189_3 | Australia | Australia | Australia |
SO51190_1 | United Kingdom | United Kingdom | United Kingdom |
SO51190_2 | United Kingdom | United Kingdom | United Kingdom |
SO51190_3 | United Kingdom | United Kingdom | United Kingdom |
SO51191_1 | Germany | Germany | Germany |
SO51191_2 | Germany | Germany | Germany |
SO51191_3 | Germany | Germany | Germany |
SO51191_4 | Germany | Germany | Germany |
SO51192_1 | France | France | France |
SO51192_2 | France | France | France |
SO51193_1 | Canada | Canada | Canada |
SO51193_2 | Canada | Canada | Canada |
SO51194_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51194_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51194_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51195_1 | Australia | Australia | Australia |
SO51216_3 | Australia | Australia | Australia |
SO51216_4 | Australia | Australia | Australia |
SO51216_5 | Australia | Australia | Australia |
SO51217_1 | Australia | Australia | Australia |
SO51217_2 | Australia | Australia | Australia |
SO51217_3 | Australia | Australia | Australia |
SO51217_4 | Australia | Australia | Australia |
SO51218_1 | Australia | Australia | Australia |
SO51219_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51220_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51220_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51221_1 | Germany | Germany | Germany |
SO51221_2 | Germany | Germany | Germany |
SO51221_3 | Germany | Germany | Germany |
SO51222_1 | United Kingdom | United Kingdom | United Kingdom |
SO51222_2 | United Kingdom | United Kingdom | United Kingdom |
SO51223_1 | Germany | Germany | Germany |
SO51223_2 | Germany | Germany | Germany |
SO51223_3 | Germany | Germany | Germany |
SO51223_4 | Germany | Germany | Germany |
SO51224_1 | France | France | France |
SO51224_2 | France | France | France |
SO51225_1 | United Kingdom | United Kingdom | United Kingdom |
SO51225_2 | United Kingdom | United Kingdom | United Kingdom |
SO51225_3 | United Kingdom | United Kingdom | United Kingdom |
SO51226_1 | United Kingdom | United Kingdom | United Kingdom |
SO51226_2 | United Kingdom | United Kingdom | United Kingdom |
SO51227_1 | Germany | Germany | Germany |
SO51227_2 | Germany | Germany | Germany |
SO51227_3 | Germany | Germany | Germany |
SO51228_1 | France | France | France |
SO51228_2 | France | France | France |
SO51228_3 | France | France | France |
SO51228_4 | France | France | France |
SO51228_5 | France | France | France |
SO51229_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51232_1 | United Kingdom | United Kingdom | United Kingdom |
SO51232_2 | United Kingdom | United Kingdom | United Kingdom |
SO51233_1 | Australia | Australia | Australia |
SO51234_1 | Australia | Australia | Australia |
SO51234_2 | Australia | Australia | Australia |
SO51235_1 | Australia | Australia | Australia |
SO51236_1 | Australia | Australia | Australia |
SO51237_1 | Australia | Australia | Australia |
SO51237_2 | Australia | Australia | Australia |
SO51237_3 | Australia | Australia | Australia |
SO51237_4 | Australia | Australia | Australia |
SO51238_1 | Australia | Australia | Australia |
SO51239_1 | Australia | Australia | Australia |
SO51239_2 | Australia | Australia | Australia |
SO51240_1 | Canada | Canada | Canada |
SO51240_2 | Canada | Canada | Canada |
SO51241_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51241_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51241_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51243_1 | United Kingdom | United Kingdom | United Kingdom |
SO51243_2 | United Kingdom | United Kingdom | United Kingdom |
SO51243_3 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-08 12:36:23.637 UTC