[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2421 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47134_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47135_1 | Canada | Canada | Canada |
SO47136_1 | Australia | Australia | Australia |
SO47137_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47202_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47203_1 | Canada | Canada | Canada |
SO47204_1 | Canada | Canada | Canada |
SO47205_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47206_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47207_1 | Canada | Canada | Canada |
SO47208_1 | Australia | Australia | Australia |
SO47209_1 | Australia | Australia | Australia |
SO46719_1 | United Kingdom | United Kingdom | United Kingdom |
SO47210_1 | Australia | Australia | Australia |
SO47146_1 | Germany | Germany | Germany |
SO46879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46720_1 | France | France | France |
SO47211_1 | Australia | Australia | Australia |
SO47147_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46880_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46721_1 | United Kingdom | United Kingdom | United Kingdom |
SO47212_1 | Australia | Australia | Australia |
SO47148_1 | Australia | Australia | Australia |
SO46881_1 | Australia | Australia | Australia |
SO46722_1 | France | France | France |
SO47213_1 | United Kingdom | United Kingdom | United Kingdom |
SO47149_1 | Australia | Australia | Australia |
SO46882_1 | Australia | Australia | Australia |
SO46723_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47214_1 | United Kingdom | United Kingdom | United Kingdom |
SO47150_1 | Germany | Germany | Germany |
SO46883_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46724_1 | Canada | Canada | Canada |
SO47215_1 | Canada | Canada | Canada |
SO47151_1 | Canada | Canada | Canada |
SO46884_1 | France | France | France |
SO46725_1 | Australia | Australia | Australia |
SO47216_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47152_1 | France | France | France |
SO46885_1 | United Kingdom | United Kingdom | United Kingdom |
SO46726_1 | Australia | Australia | Australia |
SO47217_1 | Australia | Australia | Australia |
SO47153_1 | Australia | Australia | Australia |
SO46886_1 | Canada | Canada | Canada |
SO46727_1 | Australia | Australia | Australia |
SO47218_1 | Australia | Australia | Australia |
SO47154_1 | Australia | Australia | Australia |
SO46887_1 | Australia | Australia | Australia |
SO46728_1 | Australia | Australia | Australia |
SO47219_1 | Australia | Australia | Australia |
SO47155_1 | France | France | France |
SO46888_1 | Australia | Australia | Australia |
SO46729_1 | Australia | Australia | Australia |
SO47220_1 | Australia | Australia | Australia |
SO47156_1 | Canada | Canada | Canada |
SO46889_1 | United Kingdom | United Kingdom | United Kingdom |
SO46730_1 | Germany | Germany | Germany |
SO47221_1 | France | France | France |
SO47157_1 | Canada | Canada | Canada |
SO46890_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46731_1 | Germany | Germany | Germany |
SO47222_1 | Canada | Canada | Canada |
SO47158_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46891_1 | United Kingdom | United Kingdom | United Kingdom |
SO46732_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47223_1 | Canada | Canada | Canada |
SO47159_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46892_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46733_1 | Canada | Canada | Canada |
SO47224_1 | Germany | Germany | Germany |
SO47160_1 | Australia | Australia | Australia |
SO46893_1 | Canada | Canada | Canada |
SO46734_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47225_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47161_1 | Australia | Australia | Australia |
SO46894_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46735_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47226_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47162_1 | Australia | Australia | Australia |
SO46895_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46736_1 | Australia | Australia | Australia |
SO47227_1 | Canada | Canada | Canada |
SO47163_1 | Australia | Australia | Australia |
SO46896_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46737_1 | Australia | Australia | Australia |
SO47228_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47164_1 | United Kingdom | United Kingdom | United Kingdom |
SO46897_1 | Australia | Australia | Australia |
SO46738_1 | Australia | Australia | Australia |
SO47229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47165_1 | Germany | Germany | Germany |
SO46898_1 | Australia | Australia | Australia |
SO46739_1 | United Kingdom | United Kingdom | United Kingdom |
SO47230_1 | Australia | Australia | Australia |
SO47166_1 | Germany | Germany | Germany |
SO46899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46740_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47231_1 | Germany | Germany | Germany |
SO47167_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46900_1 | Australia | Australia | Australia |
SO46741_1 | Canada | Canada | Canada |
SO47232_1 | Germany | Germany | Germany |
SO47168_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46901_1 | Australia | Australia | Australia |
SO46742_1 | Canada | Canada | Canada |
SO47233_1 | United Kingdom | United Kingdom | United Kingdom |
SO47169_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46902_1 | Australia | Australia | Australia |
SO46743_1 | Australia | Australia | Australia |
SO47234_1 | United Kingdom | United Kingdom | United Kingdom |
SO47170_1 | Australia | Australia | Australia |
SO46903_1 | Australia | Australia | Australia |
SO46744_1 | Australia | Australia | Australia |
SO47235_1 | United Kingdom | United Kingdom | United Kingdom |
SO47171_1 | Australia | Australia | Australia |
SO46904_1 | France | France | France |
SO46745_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47236_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47172_1 | Australia | Australia | Australia |
SO46905_1 | United Kingdom | United Kingdom | United Kingdom |
SO46746_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47237_1 | Canada | Canada | Canada |
SO47173_1 | Australia | Australia | Australia |
SO46906_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46747_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47238_1 | United Kingdom | United Kingdom | United Kingdom |
SO47174_1 | Australia | Australia | Australia |
SO46907_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46748_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47239_1 | Australia | Australia | Australia |
SO47175_1 | France | France | France |
SO46908_1 | Australia | Australia | Australia |
SO46749_1 | Australia | Australia | Australia |
SO47240_1 | Australia | Australia | Australia |
SO47176_1 | Germany | Germany | Germany |
SO46909_1 | Australia | Australia | Australia |
SO46750_1 | United Kingdom | United Kingdom | United Kingdom |
SO47241_1 | Australia | Australia | Australia |
SO47177_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46910_1 | United Kingdom | United Kingdom | United Kingdom |
SO46751_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47242_1 | France | France | France |
SO47178_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46911_1 | Canada | Canada | Canada |
SO46752_1 | Germany | Germany | Germany |
SO47243_1 | United Kingdom | United Kingdom | United Kingdom |
SO47179_1 | Canada | Canada | Canada |
SO46912_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46753_1 | Australia | Australia | Australia |
SO47244_1 | United Kingdom | United Kingdom | United Kingdom |
SO47180_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46913_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46754_1 | Australia | Australia | Australia |
SO47245_1 | United Kingdom | United Kingdom | United Kingdom |
SO47181_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46914_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46755_1 | Australia | Australia | Australia |
SO47246_1 | United Kingdom | United Kingdom | United Kingdom |
SO47182_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46915_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46756_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47247_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47183_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46916_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46757_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47248_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47184_1 | Australia | Australia | Australia |
SO46917_1 | Australia | Australia | Australia |
SO46758_1 | Germany | Germany | Germany |
SO47249_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47185_1 | United Kingdom | United Kingdom | United Kingdom |
SO46918_1 | Australia | Australia | Australia |
SO46759_1 | United Kingdom | United Kingdom | United Kingdom |
SO47250_1 | Australia | Australia | Australia |
SO47186_1 | France | France | France |
SO46919_1 | Germany | Germany | Germany |
SO46760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47251_1 | Australia | Australia | Australia |
SO47187_1 | Germany | Germany | Germany |
SO46920_1 | United Kingdom | United Kingdom | United Kingdom |
SO46761_1 | Germany | Germany | Germany |
SO47252_1 | Australia | Australia | Australia |
SO47188_1 | United Kingdom | United Kingdom | United Kingdom |
SO46921_1 | Germany | Germany | Germany |
SO46762_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47253_1 | Australia | Australia | Australia |
SO47189_1 | Canada | Canada | Canada |
SO46922_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46763_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47190_1 | Canada | Canada | Canada |
SO46923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46764_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47255_1 | Germany | Germany | Germany |
SO47191_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46765_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47256_1 | United Kingdom | United Kingdom | United Kingdom |
SO47192_1 | United Kingdom | United Kingdom | United Kingdom |
SO46925_1 | Australia | Australia | Australia |
SO46766_1 | Australia | Australia | Australia |
SO47257_1 | France | France | France |
SO47193_1 | Germany | Germany | Germany |
SO46926_1 | Australia | Australia | Australia |
SO46767_1 | Australia | Australia | Australia |
SO47258_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47194_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46927_1 | Australia | Australia | Australia |
SO46768_1 | Australia | Australia | Australia |
SO47259_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47195_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46928_1 | Australia | Australia | Australia |
SO46769_1 | United Kingdom | United Kingdom | United Kingdom |
SO47260_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47196_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47068_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46770_1 | Germany | Germany | Germany |
SO47261_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47197_1 | Australia | Australia | Australia |
SO47069_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46771_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47262_1 | Australia | Australia | Australia |
SO47198_1 | France | France | France |
SO47070_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46772_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47263_1 | Australia | Australia | Australia |
SO47199_1 | Germany | Germany | Germany |
SO47071_1 | Germany | Germany | Germany |
SO46773_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47264_1 | United Kingdom | United Kingdom | United Kingdom |
SO47200_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47072_1 | Germany | Germany | Germany |
SO46774_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47265_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47201_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47073_1 | Canada | Canada | Canada |
SO47569_1 | Australia | Australia | Australia |
SO47505_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47266_1 | Australia | Australia | Australia |
SO47330_1 | United Kingdom | United Kingdom | United Kingdom |
SO47570_1 | France | France | France |
SO47506_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47267_1 | Australia | Australia | Australia |
SO47331_1 | United Kingdom | United Kingdom | United Kingdom |
SO47571_1 | France | France | France |
SO47507_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47268_1 | Australia | Australia | Australia |
SO47332_1 | Canada | Canada | Canada |
Generated 2025-07-07 23:31:02.643 UTC