[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6453 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
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 |
SO51585_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51586_1 | Australia | Australia | Australia |
SO51586_2 | Australia | Australia | Australia |
SO51586_3 | Australia | Australia | Australia |
SO51586_4 | Australia | Australia | Australia |
SO51587_1 | Germany | Germany | Germany |
SO51587_2 | Germany | Germany | Germany |
SO51587_3 | Germany | Germany | Germany |
SO51543_4 | Australia | Australia | Australia |
SO51544_1 | United Kingdom | United Kingdom | United Kingdom |
SO51544_2 | United Kingdom | United Kingdom | United Kingdom |
SO51545_1 | United Kingdom | United Kingdom | United Kingdom |
SO51546_1 | Germany | Germany | Germany |
SO51546_2 | Germany | Germany | Germany |
SO51546_3 | Germany | Germany | Germany |
SO51546_4 | Germany | Germany | Germany |
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 |
SO51611_3 | Australia | Australia | Australia |
SO51611_4 | Australia | Australia | Australia |
SO51612_1 | Australia | Australia | Australia |
SO51612_2 | Australia | Australia | Australia |
SO51612_3 | Australia | Australia | Australia |
SO51612_4 | Australia | Australia | Australia |
SO51613_1 | Canada | Canada | Canada |
SO51613_2 | Canada | Canada | Canada |
SO51613_3 | Canada | Canada | Canada |
SO51614_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51614_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51615_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51615_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51616_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51616_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51616_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51616_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51617_1 | Germany | Germany | Germany |
SO51617_2 | Germany | Germany | Germany |
SO51617_3 | Germany | Germany | Germany |
SO51617_4 | Germany | Germany | Germany |
SO51617_5 | Germany | Germany | Germany |
SO51618_1 | France | France | France |
SO51619_1 | United Kingdom | United Kingdom | United Kingdom |
SO51619_2 | United Kingdom | United Kingdom | United Kingdom |
SO51620_1 | United Kingdom | United Kingdom | United Kingdom |
SO51620_2 | United Kingdom | United Kingdom | United Kingdom |
SO51620_3 | United Kingdom | United Kingdom | United Kingdom |
SO51620_4 | United Kingdom | United Kingdom | United Kingdom |
SO51621_1 | France | France | France |
SO51621_2 | France | France | France |
SO51622_1 | Germany | Germany | Germany |
SO51622_2 | Germany | Germany | Germany |
SO51622_3 | Germany | Germany | Germany |
SO51623_1 | France | France | France |
SO51623_2 | France | France | France |
SO51623_3 | France | France | France |
SO51623_4 | France | France | France |
SO51623_5 | France | France | France |
SO51624_1 | United Kingdom | United Kingdom | United Kingdom |
SO51624_2 | United Kingdom | United Kingdom | United Kingdom |
SO51624_3 | United Kingdom | United Kingdom | United Kingdom |
SO51625_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51625_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51625_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51626_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51626_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51627_1 | Australia | Australia | Australia |
SO51627_2 | Australia | Australia | Australia |
SO51627_3 | Australia | Australia | Australia |
SO51628_1 | Australia | Australia | Australia |
SO51629_1 | Australia | Australia | Australia |
SO51629_2 | Australia | Australia | Australia |
SO51629_3 | Australia | Australia | Australia |
SO51630_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51630_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51630_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51631_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51632_1 | Germany | Germany | Germany |
SO51633_1 | France | France | France |
SO51634_1 | Australia | Australia | Australia |
SO51634_2 | Australia | Australia | Australia |
SO51635_1 | Australia | Australia | Australia |
SO51635_2 | Australia | Australia | Australia |
SO51635_3 | Australia | Australia | Australia |
SO51635_4 | Australia | Australia | Australia |
SO51636_1 | Australia | Australia | Australia |
SO51636_2 | Australia | Australia | Australia |
SO51637_1 | Germany | Germany | Germany |
SO51637_2 | Germany | Germany | Germany |
SO51637_3 | Germany | Germany | Germany |
SO51638_1 | Germany | Germany | Germany |
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 |
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 |
SO51574_1 | France | France | France |
SO51574_2 | France | France | France |
SO51575_1 | France | France | France |
SO51576_1 | Germany | Germany | Germany |
SO51576_2 | Germany | Germany | Germany |
SO51577_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51578_1 | Australia | Australia | Australia |
SO51578_2 | Australia | Australia | Australia |
SO51578_3 | Australia | Australia | Australia |
SO51578_4 | Australia | Australia | Australia |
SO51578_5 | Australia | Australia | Australia |
SO51579_1 | Australia | Australia | Australia |
SO51579_2 | Australia | Australia | Australia |
SO51579_3 | Australia | Australia | Australia |
SO51579_4 | Australia | Australia | Australia |
SO51580_1 | Australia | Australia | Australia |
SO51580_2 | Australia | Australia | Australia |
SO51580_3 | Australia | Australia | Australia |
SO51581_1 | Australia | Australia | Australia |
SO51581_2 | Australia | Australia | Australia |
SO51581_3 | Australia | Australia | Australia |
SO51581_4 | Australia | Australia | Australia |
SO51581_5 | Australia | Australia | Australia |
SO51582_1 | Australia | Australia | Australia |
SO51582_2 | Australia | Australia | Australia |
SO51582_3 | Australia | Australia | Australia |
SO51582_4 | Australia | Australia | Australia |
SO51583_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51583_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51584_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51584_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51585_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51660_3 | Germany | Germany | Germany |
SO51660_4 | Germany | Germany | Germany |
SO51661_1 | United Kingdom | United Kingdom | United Kingdom |
SO51661_2 | United Kingdom | United Kingdom | United Kingdom |
SO51661_3 | United Kingdom | United Kingdom | United Kingdom |
SO51661_4 | United Kingdom | United Kingdom | United Kingdom |
SO51662_1 | Germany | Germany | Germany |
SO51663_1 | Germany | Germany | Germany |
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 |
SO51590_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51590_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51590_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51591_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51591_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51592_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51592_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51593_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51593_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51594_1 | Australia | Australia | Australia |
SO51594_2 | Australia | Australia | Australia |
SO51594_3 | Australia | Australia | Australia |
SO51595_1 | Australia | Australia | Australia |
SO51595_2 | Australia | Australia | Australia |
SO51595_3 | Australia | Australia | Australia |
SO51596_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51596_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51597_1 | Australia | Australia | Australia |
SO51597_2 | Australia | Australia | Australia |
SO51597_3 | Australia | Australia | Australia |
SO51598_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51599_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51599_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51600_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51601_1 | United Kingdom | United Kingdom | United Kingdom |
SO51602_1 | France | France | France |
SO51602_2 | France | France | France |
SO51603_1 | United Kingdom | United Kingdom | United Kingdom |
SO51603_2 | United Kingdom | United Kingdom | United Kingdom |
SO51604_1 | Germany | Germany | Germany |
SO51604_2 | Germany | Germany | Germany |
SO51605_1 | United Kingdom | United Kingdom | United Kingdom |
SO51605_2 | United Kingdom | United Kingdom | United Kingdom |
SO51605_3 | United Kingdom | United Kingdom | United Kingdom |
SO51605_4 | United Kingdom | United Kingdom | United Kingdom |
SO51606_1 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-08 01:09:13.970 UTC