[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6421 > < TAKE 124 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
124 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51528_2 | Australia | Australia | Australia |
SO51528_3 | Australia | Australia | Australia |
SO51529_1 | Australia | Australia | Australia |
SO51529_2 | Australia | Australia | Australia |
SO51529_3 | Australia | Australia | Australia |
SO51529_4 | Australia | Australia | Australia |
SO51530_1 | United Kingdom | United Kingdom | United Kingdom |
SO51531_1 | United Kingdom | United Kingdom | United Kingdom |
SO51531_2 | United Kingdom | United Kingdom | United Kingdom |
SO51531_3 | United Kingdom | United Kingdom | United Kingdom |
SO51531_4 | United Kingdom | United Kingdom | United Kingdom |
SO51532_1 | United Kingdom | United Kingdom | United Kingdom |
SO51532_2 | United Kingdom | United Kingdom | United Kingdom |
SO51533_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51534_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51534_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51534_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51535_1 | Australia | Australia | Australia |
SO51536_1 | Australia | Australia | Australia |
SO51536_2 | Australia | Australia | Australia |
SO51537_1 | Australia | Australia | Australia |
SO51537_2 | Australia | Australia | Australia |
SO51538_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51538_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51539_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51539_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51539_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51540_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51540_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51541_1 | United Kingdom | United Kingdom | United Kingdom |
SO51541_2 | United Kingdom | United Kingdom | United Kingdom |
SO51541_3 | United Kingdom | United Kingdom | United Kingdom |
SO51542_1 | United Kingdom | United Kingdom | United Kingdom |
SO51543_1 | Australia | Australia | Australia |
SO51543_2 | Australia | Australia | Australia |
SO51543_3 | Australia | Australia | Australia |
SO51564_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51564_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51565_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51565_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51565_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51566_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51566_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51566_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51547_1 | France | France | France |
SO51547_2 | France | France | France |
SO51548_1 | United Kingdom | United Kingdom | United Kingdom |
SO51548_2 | United Kingdom | United Kingdom | United Kingdom |
SO51548_3 | United Kingdom | United Kingdom | United Kingdom |
SO51548_4 | United Kingdom | United Kingdom | United Kingdom |
SO51549_1 | United Kingdom | United Kingdom | United Kingdom |
SO51549_2 | United Kingdom | United Kingdom | United Kingdom |
SO51549_3 | United Kingdom | United Kingdom | United Kingdom |
SO51549_4 | United Kingdom | United Kingdom | United Kingdom |
SO51550_1 | United Kingdom | United Kingdom | United Kingdom |
SO51550_2 | United Kingdom | United Kingdom | United Kingdom |
SO51551_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51551_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51551_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51551_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51552_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51552_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51552_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51553_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51553_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51553_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51553_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51554_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51554_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51554_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51554_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_1 | Canada | Canada | Canada |
SO51555_2 | Canada | Canada | Canada |
SO51555_3 | Canada | Canada | Canada |
SO51555_4 | Canada | Canada | Canada |
SO51555_5 | Canada | Canada | Canada |
SO51555_6 | Canada | Canada | Canada |
SO51555_7 | Canada | Canada | Canada |
SO51556_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51556_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51557_1 | Germany | Germany | Germany |
SO51558_1 | Australia | Australia | Australia |
SO51558_2 | Australia | Australia | Australia |
SO51558_3 | Australia | Australia | Australia |
SO51558_4 | Australia | Australia | Australia |
SO51559_1 | Australia | Australia | Australia |
SO51559_2 | Australia | Australia | Australia |
SO51559_3 | Australia | Australia | Australia |
SO51559_4 | Australia | Australia | Australia |
SO51560_1 | Australia | Australia | Australia |
SO51560_2 | Australia | Australia | Australia |
SO51561_1 | Australia | Australia | Australia |
SO51561_2 | Australia | Australia | Australia |
SO51561_3 | Australia | Australia | Australia |
SO51562_1 | Australia | Australia | Australia |
SO51562_2 | Australia | Australia | Australia |
SO51563_1 | Australia | Australia | Australia |
SO51563_2 | Australia | Australia | Australia |
SO51563_3 | Australia | Australia | Australia |
SO51563_4 | Australia | Australia | Australia |
SO51588_1 | Germany | Germany | Germany |
SO51588_2 | Germany | Germany | Germany |
SO51588_3 | Germany | Germany | Germany |
SO51588_4 | Germany | Germany | Germany |
SO51589_1 | France | France | France |
SO51589_2 | France | France | France |
SO51589_3 | France | France | France |
SO51590_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51567_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51567_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51567_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51568_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51568_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51570_1 | Germany | Germany | Germany |
SO51571_1 | Australia | Australia | Australia |
SO51571_2 | Australia | Australia | Australia |
SO51572_1 | Germany | Germany | Germany |
SO51572_2 | Germany | Germany | Germany |
SO51573_1 | United Kingdom | United Kingdom | United Kingdom |
SO51573_2 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-15 15:39:03.739 UTC