[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2220 > < TAKE 240 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
240 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO46858_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46859_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46860_1 | Australia | Australia | Australia |
SO46861_1 | Australia | Australia | Australia |
SO46862_1 | United Kingdom | United Kingdom | United Kingdom |
SO46863_1 | United Kingdom | United Kingdom | United Kingdom |
SO46864_1 | United Kingdom | United Kingdom | United Kingdom |
SO46865_1 | Germany | Germany | Germany |
SO46866_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46867_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46868_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46869_1 | France | France | France |
SO46870_1 | France | France | France |
SO46871_1 | France | France | France |
SO46872_1 | United Kingdom | United Kingdom | United Kingdom |
SO46873_1 | Australia | Australia | Australia |
SO46874_1 | Australia | Australia | Australia |
SO46875_1 | Germany | Germany | Germany |
SO46876_1 | Germany | Germany | Germany |
SO46877_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46878_1 | Canada | Canada | Canada |
SO46879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46751_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46291_1 | Australia | Australia | Australia |
SO46551_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46880_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46752_1 | Germany | Germany | Germany |
SO46292_1 | Australia | Australia | Australia |
SO46552_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46881_1 | Australia | Australia | Australia |
SO46753_1 | Australia | Australia | Australia |
SO46293_1 | Germany | Germany | Germany |
SO46553_1 | Australia | Australia | Australia |
SO46882_1 | Australia | Australia | Australia |
SO46754_1 | Australia | Australia | Australia |
SO46294_1 | Australia | Australia | Australia |
SO46554_1 | Australia | Australia | Australia |
SO46883_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46755_1 | Australia | Australia | Australia |
SO46295_1 | United Kingdom | United Kingdom | United Kingdom |
SO46555_1 | Australia | Australia | Australia |
SO46884_1 | France | France | France |
SO46756_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46296_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46556_1 | Australia | Australia | Australia |
SO46885_1 | United Kingdom | United Kingdom | United Kingdom |
SO46757_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46297_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46557_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46886_1 | Canada | Canada | Canada |
SO46758_1 | Germany | Germany | Germany |
SO46298_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46558_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46887_1 | Australia | Australia | Australia |
SO46759_1 | United Kingdom | United Kingdom | United Kingdom |
SO46299_1 | Australia | Australia | Australia |
SO46559_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46888_1 | Australia | Australia | Australia |
SO46760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46300_1 | Australia | Australia | Australia |
SO46560_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46889_1 | United Kingdom | United Kingdom | United Kingdom |
SO46761_1 | Germany | Germany | Germany |
SO46301_1 | France | France | France |
SO46561_1 | Australia | Australia | Australia |
SO46890_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46762_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46302_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46562_1 | Germany | Germany | Germany |
SO46891_1 | United Kingdom | United Kingdom | United Kingdom |
SO46763_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46303_1 | Australia | Australia | Australia |
SO46563_1 | Australia | Australia | Australia |
SO46892_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46764_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46304_1 | Australia | Australia | Australia |
SO46564_1 | United Kingdom | United Kingdom | United Kingdom |
SO46893_1 | Canada | Canada | Canada |
SO46765_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46305_1 | Germany | Germany | Germany |
SO46565_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46894_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46766_1 | Australia | Australia | Australia |
SO46306_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46566_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46895_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46767_1 | Australia | Australia | Australia |
SO46307_1 | Australia | Australia | Australia |
SO46567_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46896_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46768_1 | Australia | Australia | Australia |
SO46308_1 | Australia | Australia | Australia |
SO46568_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46897_1 | Australia | Australia | Australia |
SO46769_1 | United Kingdom | United Kingdom | United Kingdom |
SO46309_1 | Australia | Australia | Australia |
SO46569_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46898_1 | Australia | Australia | Australia |
SO46770_1 | Germany | Germany | Germany |
SO46310_1 | Australia | Australia | Australia |
SO46570_1 | France | France | France |
SO46899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46771_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46311_1 | France | France | France |
SO46571_1 | United Kingdom | United Kingdom | United Kingdom |
SO46900_1 | Australia | Australia | Australia |
SO46772_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46312_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46572_1 | France | France | France |
SO46901_1 | Australia | Australia | Australia |
SO46773_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46313_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46573_1 | France | France | France |
SO46902_1 | Australia | Australia | Australia |
SO46774_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46314_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46574_1 | Australia | Australia | Australia |
SO46903_1 | Australia | Australia | Australia |
SO46775_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46315_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46575_1 | Australia | Australia | Australia |
SO46904_1 | France | France | France |
SO46776_1 | Australia | Australia | Australia |
SO46316_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46576_1 | Canada | Canada | Canada |
SO46905_1 | United Kingdom | United Kingdom | United Kingdom |
SO46777_1 | United Kingdom | United Kingdom | United Kingdom |
SO46317_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46577_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46906_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46778_1 | United Kingdom | United Kingdom | United Kingdom |
SO46318_1 | Australia | Australia | Australia |
SO46578_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46907_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46779_1 | United Kingdom | United Kingdom | United Kingdom |
SO46319_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46579_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46908_1 | Australia | Australia | Australia |
SO46780_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46320_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46580_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46909_1 | Australia | Australia | Australia |
SO46781_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46321_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46581_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46910_1 | United Kingdom | United Kingdom | United Kingdom |
SO46782_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46390_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46582_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46911_1 | Canada | Canada | Canada |
SO46783_1 | France | France | France |
SO46391_1 | Australia | Australia | Australia |
SO46583_1 | Australia | Australia | Australia |
SO46912_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46784_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46392_1 | France | France | France |
SO46584_1 | Australia | Australia | Australia |
SO46913_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46785_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46393_1 | United Kingdom | United Kingdom | United Kingdom |
SO46585_1 | Germany | Germany | Germany |
SO46914_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46786_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46394_1 | Germany | Germany | Germany |
SO46586_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46915_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46787_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46395_1 | United Kingdom | United Kingdom | United Kingdom |
SO46587_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46916_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46788_1 | Australia | Australia | Australia |
SO46396_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46588_1 | Canada | Canada | Canada |
SO46917_1 | Australia | Australia | Australia |
SO46789_1 | France | France | France |
SO46397_1 | Canada | Canada | Canada |
SO46589_1 | Australia | Australia | Australia |
SO46918_1 | Australia | Australia | Australia |
SO46790_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46398_1 | Australia | Australia | Australia |
SO46590_1 | Canada | Canada | Canada |
SO46919_1 | Germany | Germany | Germany |
SO46791_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46399_1 | Australia | Australia | Australia |
SO46591_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46920_1 | United Kingdom | United Kingdom | United Kingdom |
SO46792_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46400_1 | Australia | Australia | Australia |
SO46592_1 | Canada | Canada | Canada |
SO46921_1 | Germany | Germany | Germany |
SO46793_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46401_1 | Australia | Australia | Australia |
SO46593_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46922_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46794_1 | Canada | Canada | Canada |
SO46402_1 | Australia | Australia | Australia |
SO46594_1 | Australia | Australia | Australia |
SO46923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46795_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46403_1 | Germany | Germany | Germany |
SO46595_1 | United Kingdom | United Kingdom | United Kingdom |
SO46924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46796_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46404_1 | United Kingdom | United Kingdom | United Kingdom |
SO46596_1 | Australia | Australia | Australia |
SO46925_1 | Australia | Australia | Australia |
SO46797_1 | Australia | Australia | Australia |
SO46405_1 | Australia | Australia | Australia |
SO46597_1 | Australia | Australia | Australia |
SO46926_1 | Australia | Australia | Australia |
SO46798_1 | Australia | Australia | Australia |
SO46406_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46598_1 | Germany | Germany | Germany |
SO46927_1 | Australia | Australia | Australia |
SO46799_1 | France | France | France |
SO46407_1 | Canada | Canada | Canada |
SO46599_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46928_1 | Australia | Australia | Australia |
SO46800_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46408_1 | Australia | Australia | Australia |
SO46600_1 | France | France | France |
SO47068_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46801_1 | Canada | Canada | Canada |
SO46409_1 | Germany | Germany | Germany |
SO46601_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47069_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46802_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46410_1 | United Kingdom | United Kingdom | United Kingdom |
SO46602_1 | Australia | Australia | Australia |
SO47070_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46803_1 | France | France | France |
SO46411_1 | Canada | Canada | Canada |
SO46603_1 | Australia | Australia | Australia |
SO47071_1 | Germany | Germany | Germany |
SO46804_1 | France | France | France |
SO46412_1 | Canada | Canada | Canada |
SO46676_1 | Germany | Germany | Germany |
SO47072_1 | Germany | Germany | Germany |
SO46805_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46413_1 | Canada | Canada | Canada |
Generated 2025-07-10 19:34:28.720 UTC