[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 6285 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51475_4 | Germany | Germany | Germany |
SO51476_1 | United Kingdom | United Kingdom | United Kingdom |
SO51476_2 | United Kingdom | United Kingdom | United Kingdom |
SO51477_1 | United Kingdom | United Kingdom | United Kingdom |
SO51477_2 | United Kingdom | United Kingdom | United Kingdom |
SO51478_1 | Australia | Australia | Australia |
SO51478_2 | Australia | Australia | Australia |
SO51478_3 | Australia | Australia | Australia |
SO51478_4 | Australia | Australia | Australia |
SO51479_1 | Australia | Australia | Australia |
SO51479_2 | Australia | Australia | Australia |
SO51479_3 | Australia | Australia | Australia |
SO51479_4 | Australia | Australia | Australia |
SO51480_1 | France | France | France |
SO51480_2 | France | France | France |
SO51480_3 | France | France | France |
SO51481_1 | United Kingdom | United Kingdom | United Kingdom |
SO51481_2 | United Kingdom | United Kingdom | United Kingdom |
SO51482_1 | Germany | Germany | Germany |
SO51482_2 | Germany | Germany | Germany |
SO51482_3 | Germany | Germany | Germany |
SO51483_1 | United Kingdom | United Kingdom | United Kingdom |
SO51483_2 | United Kingdom | United Kingdom | United Kingdom |
SO51483_3 | United Kingdom | United Kingdom | United Kingdom |
SO51483_4 | United Kingdom | United Kingdom | United Kingdom |
SO51484_1 | United Kingdom | United Kingdom | United Kingdom |
SO51484_2 | United Kingdom | United Kingdom | United Kingdom |
SO51485_1 | Germany | Germany | Germany |
SO51485_2 | Germany | Germany | Germany |
SO51485_3 | Germany | Germany | Germany |
SO51486_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51486_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51487_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51488_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51489_1 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO51513_3 | France | France | France |
SO51561_2 | Australia | Australia | Australia |
SO51447_2 | Australia | Australia | Australia |
SO51540_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51514_1 | United Kingdom | United Kingdom | United Kingdom |
SO51561_3 | Australia | Australia | Australia |
SO51447_3 | Australia | Australia | Australia |
SO51541_1 | United Kingdom | United Kingdom | United Kingdom |
SO51514_2 | United Kingdom | United Kingdom | United Kingdom |
SO51562_1 | Australia | Australia | Australia |
SO51448_1 | Australia | Australia | Australia |
SO51541_2 | United Kingdom | United Kingdom | United Kingdom |
SO51514_3 | United Kingdom | United Kingdom | United Kingdom |
SO51562_2 | Australia | Australia | Australia |
SO51448_2 | Australia | Australia | Australia |
SO51541_3 | United Kingdom | United Kingdom | United Kingdom |
SO51515_1 | France | France | France |
SO51563_1 | Australia | Australia | Australia |
SO51448_3 | Australia | Australia | Australia |
SO51542_1 | United Kingdom | United Kingdom | United Kingdom |
SO51516_1 | Germany | Germany | Germany |
SO51563_2 | Australia | Australia | Australia |
SO51449_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51543_1 | Australia | Australia | Australia |
SO51517_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51563_3 | Australia | Australia | Australia |
SO51449_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51543_2 | Australia | Australia | Australia |
SO51517_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51563_4 | Australia | Australia | Australia |
SO51450_1 | Australia | Australia | Australia |
SO51543_3 | Australia | Australia | Australia |
SO51517_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51564_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51450_2 | Australia | Australia | Australia |
SO51543_4 | Australia | Australia | Australia |
SO51518_1 | Canada | Canada | Canada |
SO51564_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51451_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51544_1 | United Kingdom | United Kingdom | United Kingdom |
SO51518_2 | Canada | Canada | Canada |
SO51565_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51452_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51544_2 | United Kingdom | United Kingdom | United Kingdom |
SO51518_3 | Canada | Canada | Canada |
SO51565_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51452_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51545_1 | United Kingdom | United Kingdom | United Kingdom |
SO51518_4 | Canada | Canada | Canada |
SO51565_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51452_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51546_1 | Germany | Germany | Germany |
SO51519_1 | Canada | Canada | Canada |
SO51566_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_1 | United Kingdom | United Kingdom | United Kingdom |
SO51546_2 | Germany | Germany | Germany |
SO51519_2 | Canada | Canada | Canada |
SO51566_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_2 | United Kingdom | United Kingdom | United Kingdom |
SO51546_3 | Germany | Germany | Germany |
SO51520_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51566_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_3 | United Kingdom | United Kingdom | United Kingdom |
SO51546_4 | Germany | Germany | Germany |
SO51520_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51567_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51453_4 | United Kingdom | United Kingdom | United Kingdom |
SO51547_1 | France | France | France |
SO51520_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51567_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51454_1 | Germany | Germany | Germany |
SO51547_2 | France | France | France |
SO51521_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51567_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51454_2 | Germany | Germany | Germany |
SO51548_1 | United Kingdom | United Kingdom | United Kingdom |
SO51522_1 | Australia | Australia | Australia |
SO51568_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51454_3 | Germany | Germany | Germany |
SO51548_2 | United Kingdom | United Kingdom | United Kingdom |
SO51522_2 | Australia | Australia | Australia |
SO51568_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51454_4 | Germany | Germany | Germany |
SO51548_3 | United Kingdom | United Kingdom | United Kingdom |
SO51523_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51455_1 | Germany | Germany | Germany |
SO51548_4 | United Kingdom | United Kingdom | United Kingdom |
SO51523_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51455_2 | Germany | Germany | Germany |
SO51549_1 | United Kingdom | United Kingdom | United Kingdom |
SO51523_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51456_1 | United Kingdom | United Kingdom | United Kingdom |
SO51549_2 | United Kingdom | United Kingdom | United Kingdom |
SO51523_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51569_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51456_2 | United Kingdom | United Kingdom | United Kingdom |
SO51549_3 | United Kingdom | United Kingdom | United Kingdom |
SO51524_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51570_1 | Germany | Germany | Germany |
SO51457_1 | United Kingdom | United Kingdom | United Kingdom |
SO51549_4 | United Kingdom | United Kingdom | United Kingdom |
SO51524_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51571_1 | Australia | Australia | Australia |
SO51457_2 | United Kingdom | United Kingdom | United Kingdom |
SO51550_1 | United Kingdom | United Kingdom | United Kingdom |
SO51524_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51571_2 | Australia | Australia | Australia |
SO51458_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51550_2 | United Kingdom | United Kingdom | United Kingdom |
SO51524_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51572_1 | Germany | Germany | Germany |
SO51458_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51551_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51525_1 | United Kingdom | United Kingdom | United Kingdom |
SO51572_2 | Germany | Germany | Germany |
SO51458_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51551_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51525_2 | United Kingdom | United Kingdom | United Kingdom |
SO51573_1 | United Kingdom | United Kingdom | United Kingdom |
SO51459_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51551_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51526_1 | United Kingdom | United Kingdom | United Kingdom |
SO51573_2 | United Kingdom | United Kingdom | United Kingdom |
SO51459_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51551_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51526_2 | United Kingdom | United Kingdom | United Kingdom |
SO51574_1 | France | France | France |
SO51459_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51552_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51527_1 | France | France | France |
SO51574_2 | France | France | France |
SO51460_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51552_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51527_2 | France | France | France |
SO51575_1 | France | France | France |
SO51460_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51552_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51528_1 | Australia | Australia | Australia |
SO51576_1 | Germany | Germany | Germany |
SO51460_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51553_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51528_2 | Australia | Australia | Australia |
SO51576_2 | Germany | Germany | Germany |
SO51461_1 | United Kingdom | United Kingdom | United Kingdom |
SO51553_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51528_3 | Australia | Australia | Australia |
SO51577_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51461_2 | United Kingdom | United Kingdom | United Kingdom |
SO51553_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51529_1 | Australia | Australia | Australia |
SO51578_1 | Australia | Australia | Australia |
SO51461_3 | United Kingdom | United Kingdom | United Kingdom |
SO51553_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51529_2 | Australia | Australia | Australia |
SO51578_2 | Australia | Australia | Australia |
SO51462_1 | Australia | Australia | Australia |
SO51554_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51529_3 | Australia | Australia | Australia |
SO51578_3 | Australia | Australia | Australia |
SO51462_2 | Australia | Australia | Australia |
SO51554_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51529_4 | Australia | Australia | Australia |
SO51578_4 | Australia | Australia | Australia |
SO51463_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51554_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51530_1 | United Kingdom | United Kingdom | United Kingdom |
SO51578_5 | Australia | Australia | Australia |
SO51464_1 | United Kingdom | United Kingdom | United Kingdom |
SO51554_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51531_1 | United Kingdom | United Kingdom | United Kingdom |
SO51579_1 | Australia | Australia | Australia |
SO51464_2 | United Kingdom | United Kingdom | United Kingdom |
SO51555_1 | Canada | Canada | Canada |
SO51531_2 | United Kingdom | United Kingdom | United Kingdom |
SO51579_2 | Australia | Australia | Australia |
SO51465_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_2 | Canada | Canada | Canada |
SO51531_3 | United Kingdom | United Kingdom | United Kingdom |
SO51579_3 | Australia | Australia | Australia |
SO51465_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_3 | Canada | Canada | Canada |
SO51531_4 | United Kingdom | United Kingdom | United Kingdom |
SO51579_4 | Australia | Australia | Australia |
SO51465_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_4 | Canada | Canada | Canada |
SO51532_1 | United Kingdom | United Kingdom | United Kingdom |
SO51580_1 | Australia | Australia | Australia |
SO51466_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_5 | Canada | Canada | Canada |
SO51532_2 | United Kingdom | United Kingdom | United Kingdom |
SO51580_2 | Australia | Australia | Australia |
SO51466_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51555_6 | Canada | Canada | Canada |
Generated 2025-07-13 19:27:37.951 UTC