[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2279 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO46595_1 | United Kingdom | United Kingdom | United Kingdom |
SO46860_1 | Australia | Australia | Australia |
SO46564_1 | United Kingdom | United Kingdom | United Kingdom |
SO46596_1 | Australia | Australia | Australia |
SO46861_1 | Australia | Australia | Australia |
SO46565_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46597_1 | Australia | Australia | Australia |
SO46862_1 | United Kingdom | United Kingdom | United Kingdom |
SO46566_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46598_1 | Germany | Germany | Germany |
SO46863_1 | United Kingdom | United Kingdom | United Kingdom |
SO46567_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46599_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46864_1 | United Kingdom | United Kingdom | United Kingdom |
SO46568_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46600_1 | France | France | France |
SO46865_1 | Germany | Germany | Germany |
SO46569_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46601_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46866_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46570_1 | France | France | France |
SO46602_1 | Australia | Australia | Australia |
SO46867_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46571_1 | United Kingdom | United Kingdom | United Kingdom |
SO46603_1 | Australia | Australia | Australia |
SO46868_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46572_1 | France | France | France |
SO46676_1 | Germany | Germany | Germany |
SO46869_1 | France | France | France |
SO46573_1 | France | France | France |
SO46677_1 | Germany | Germany | Germany |
SO46870_1 | France | France | France |
SO46574_1 | Australia | Australia | Australia |
SO46678_1 | Germany | Germany | Germany |
SO46871_1 | France | France | France |
SO46903_1 | Australia | Australia | Australia |
SO46679_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46872_1 | United Kingdom | United Kingdom | United Kingdom |
SO46904_1 | France | France | France |
SO46680_1 | Australia | Australia | Australia |
SO46873_1 | Australia | Australia | Australia |
SO46905_1 | United Kingdom | United Kingdom | United Kingdom |
SO46681_1 | Australia | Australia | Australia |
SO46874_1 | Australia | Australia | Australia |
SO46906_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46682_1 | Australia | Australia | Australia |
SO46875_1 | Germany | Germany | Germany |
SO46907_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46683_1 | Australia | Australia | Australia |
SO46876_1 | Germany | Germany | Germany |
SO46908_1 | Australia | Australia | Australia |
SO46684_1 | Germany | Germany | Germany |
SO46877_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46909_1 | Australia | Australia | Australia |
SO46685_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46878_1 | Canada | Canada | Canada |
SO46910_1 | United Kingdom | United Kingdom | United Kingdom |
SO46686_1 | United Kingdom | United Kingdom | United Kingdom |
SO46879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46911_1 | Canada | Canada | Canada |
SO46687_1 | Germany | Germany | Germany |
SO46880_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46912_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46688_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46881_1 | Australia | Australia | Australia |
SO46913_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46689_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46882_1 | Australia | Australia | Australia |
SO46914_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46690_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46883_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46915_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46691_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46884_1 | France | France | France |
SO46916_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46692_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46885_1 | United Kingdom | United Kingdom | United Kingdom |
SO46917_1 | Australia | Australia | Australia |
SO46693_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46886_1 | Canada | Canada | Canada |
SO46918_1 | Australia | Australia | Australia |
SO46694_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46887_1 | Australia | Australia | Australia |
SO46919_1 | Germany | Germany | Germany |
SO46695_1 | Canada | Canada | Canada |
SO46888_1 | Australia | Australia | Australia |
SO46920_1 | United Kingdom | United Kingdom | United Kingdom |
SO46696_1 | Australia | Australia | Australia |
SO46889_1 | United Kingdom | United Kingdom | United Kingdom |
SO46921_1 | Germany | Germany | Germany |
SO46697_1 | Australia | Australia | Australia |
SO46890_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46922_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46698_1 | Australia | Australia | Australia |
SO46891_1 | United Kingdom | United Kingdom | United Kingdom |
SO46923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46699_1 | Australia | Australia | Australia |
SO46892_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46700_1 | France | France | France |
SO46893_1 | Canada | Canada | Canada |
SO46925_1 | Australia | Australia | Australia |
SO46701_1 | Germany | Germany | Germany |
SO46894_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46926_1 | Australia | Australia | Australia |
SO46702_1 | Germany | Germany | Germany |
SO46895_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46927_1 | Australia | Australia | Australia |
SO46703_1 | United Kingdom | United Kingdom | United Kingdom |
SO46896_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46928_1 | Australia | Australia | Australia |
SO46704_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46897_1 | Australia | Australia | Australia |
SO47068_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46705_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46898_1 | Australia | Australia | Australia |
SO47069_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46706_1 | Canada | Canada | Canada |
SO46899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47070_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46707_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46900_1 | Australia | Australia | Australia |
SO47071_1 | Germany | Germany | Germany |
SO46708_1 | Australia | Australia | Australia |
SO46901_1 | Australia | Australia | Australia |
SO47072_1 | Germany | Germany | Germany |
SO46709_1 | United Kingdom | United Kingdom | United Kingdom |
SO46902_1 | Australia | Australia | Australia |
SO47073_1 | Canada | Canada | Canada |
SO46710_1 | Germany | Germany | Germany |
SO47170_1 | Australia | Australia | Australia |
SO47074_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47106_1 | Canada | Canada | Canada |
SO47171_1 | Australia | Australia | Australia |
SO47075_1 | Australia | Australia | Australia |
SO47107_1 | United Kingdom | United Kingdom | United Kingdom |
SO47172_1 | Australia | Australia | Australia |
SO47076_1 | Australia | Australia | Australia |
SO47108_1 | France | France | France |
SO47173_1 | Australia | Australia | Australia |
SO47077_1 | United Kingdom | United Kingdom | United Kingdom |
SO47109_1 | Canada | Canada | Canada |
SO47174_1 | Australia | Australia | Australia |
SO47078_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47110_1 | Canada | Canada | Canada |
SO47175_1 | France | France | France |
SO47079_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47111_1 | Canada | Canada | Canada |
SO47176_1 | Germany | Germany | Germany |
SO47080_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47112_1 | Canada | Canada | Canada |
SO47177_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47081_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47113_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46719_1 | United Kingdom | United Kingdom | United Kingdom |
SO46720_1 | France | France | France |
SO46721_1 | United Kingdom | United Kingdom | United Kingdom |
SO46722_1 | France | France | France |
SO46723_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46724_1 | Canada | Canada | Canada |
SO46725_1 | Australia | Australia | Australia |
SO46726_1 | Australia | Australia | Australia |
SO46727_1 | Australia | Australia | Australia |
SO46728_1 | Australia | Australia | Australia |
SO46729_1 | Australia | Australia | Australia |
SO46730_1 | Germany | Germany | Germany |
SO46731_1 | Germany | Germany | Germany |
SO46732_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46733_1 | Canada | Canada | Canada |
SO46734_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46735_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46736_1 | Australia | Australia | Australia |
SO46737_1 | Australia | Australia | Australia |
SO46738_1 | Australia | Australia | Australia |
SO46739_1 | United Kingdom | United Kingdom | United Kingdom |
SO46740_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46741_1 | Canada | Canada | Canada |
SO46742_1 | Canada | Canada | Canada |
SO46743_1 | Australia | Australia | Australia |
SO46744_1 | Australia | Australia | Australia |
SO46745_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46746_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46747_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46748_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46749_1 | Australia | Australia | Australia |
SO46750_1 | United Kingdom | United Kingdom | United Kingdom |
SO46751_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46752_1 | Germany | Germany | Germany |
SO46753_1 | Australia | Australia | Australia |
SO46754_1 | Australia | Australia | Australia |
SO46755_1 | Australia | Australia | Australia |
SO46756_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46757_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46758_1 | Germany | Germany | Germany |
SO46759_1 | United Kingdom | United Kingdom | United Kingdom |
SO46760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46761_1 | Germany | Germany | Germany |
SO46762_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46763_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46764_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46765_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46766_1 | Australia | Australia | Australia |
SO46767_1 | Australia | Australia | Australia |
SO46768_1 | Australia | Australia | Australia |
SO46769_1 | United Kingdom | United Kingdom | United Kingdom |
SO46770_1 | Germany | Germany | Germany |
SO46771_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46772_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46773_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46774_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47234_1 | United Kingdom | United Kingdom | United Kingdom |
SO47235_1 | United Kingdom | United Kingdom | United Kingdom |
SO47236_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47237_1 | Canada | Canada | Canada |
SO47238_1 | United Kingdom | United Kingdom | United Kingdom |
SO47239_1 | Australia | Australia | Australia |
SO47240_1 | Australia | Australia | Australia |
SO47241_1 | Australia | Australia | Australia |
SO47114_1 | Australia | Australia | Australia |
SO47115_1 | Australia | Australia | Australia |
SO47116_1 | Australia | Australia | Australia |
SO47117_1 | Australia | Australia | Australia |
SO47118_1 | France | France | France |
SO47119_1 | United Kingdom | United Kingdom | United Kingdom |
SO47120_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47121_1 | Canada | Canada | Canada |
SO47122_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47123_1 | Canada | Canada | Canada |
SO47124_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47125_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47126_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47127_1 | Australia | Australia | Australia |
SO47128_1 | Australia | Australia | Australia |
SO47129_1 | Australia | Australia | Australia |
SO47130_1 | United Kingdom | United Kingdom | United Kingdom |
SO47131_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47132_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47133_1 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO47138_1 | United Kingdom | United Kingdom | United Kingdom |
SO47139_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47140_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47141_1 | Australia | Australia | Australia |
SO47142_1 | Australia | Australia | Australia |
SO47143_1 | Australia | Australia | Australia |
Generated 2025-07-08 16:43:43.798 UTC