[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4390 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49911_1 | United Kingdom | United Kingdom | United Kingdom |
SO49912_1 | Australia | Australia | Australia |
SO49913_1 | Australia | Australia | Australia |
SO49914_1 | Australia | Australia | Australia |
SO49915_1 | Australia | Australia | Australia |
SO49916_1 | Australia | Australia | Australia |
SO49917_1 | Australia | Australia | Australia |
SO49918_1 | Australia | Australia | Australia |
SO49919_1 | Germany | Germany | Germany |
SO49920_1 | United Kingdom | United Kingdom | United Kingdom |
SO49921_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49922_1 | Australia | Australia | Australia |
SO49923_1 | Australia | Australia | Australia |
SO49924_1 | Canada | Canada | Canada |
SO49925_1 | France | France | France |
SO49926_1 | France | France | France |
SO49927_1 | France | France | France |
SO49928_1 | France | France | France |
SO49929_1 | France | France | France |
SO50058_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50059_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50060_1 | Australia | Australia | Australia |
SO50061_1 | Australia | Australia | Australia |
SO50062_1 | Australia | Australia | Australia |
SO50063_1 | Australia | Australia | Australia |
SO50064_1 | Australia | Australia | Australia |
SO50065_1 | Australia | Australia | Australia |
SO50002_1 | Australia | Australia | Australia |
SO50003_1 | Australia | Australia | Australia |
SO50004_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50005_1 | Germany | Germany | Germany |
SO50006_1 | Germany | Germany | Germany |
SO50007_1 | Australia | Australia | Australia |
SO50008_1 | Australia | Australia | Australia |
SO50009_1 | Australia | Australia | Australia |
SO50010_1 | Australia | Australia | Australia |
SO50011_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50012_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50013_1 | United Kingdom | United Kingdom | United Kingdom |
SO50014_1 | Germany | Germany | Germany |
SO50015_1 | Germany | Germany | Germany |
SO50016_1 | Germany | Germany | Germany |
SO50017_1 | United Kingdom | United Kingdom | United Kingdom |
SO50018_1 | Germany | Germany | Germany |
SO50019_1 | Canada | Canada | Canada |
SO50020_1 | Germany | Germany | Germany |
SO50021_1 | United Kingdom | United Kingdom | United Kingdom |
SO50022_1 | Germany | Germany | Germany |
SO50023_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50024_1 | Canada | Canada | Canada |
SO50025_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50026_1 | Australia | Australia | Australia |
SO50027_1 | Australia | Australia | Australia |
SO50028_1 | Australia | Australia | Australia |
SO50029_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50030_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50031_1 | France | France | France |
SO50032_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50033_1 | Germany | Germany | Germany |
SO50034_1 | Australia | Australia | Australia |
SO50035_1 | Australia | Australia | Australia |
SO50036_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50037_1 | France | France | France |
SO50038_1 | Germany | Germany | Germany |
SO50039_1 | United Kingdom | United Kingdom | United Kingdom |
SO50040_1 | Australia | Australia | Australia |
SO50041_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50042_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50043_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50044_1 | Australia | Australia | Australia |
SO50045_1 | Australia | Australia | Australia |
SO50046_1 | France | France | France |
SO50047_1 | France | France | France |
SO50048_1 | Germany | Germany | Germany |
SO50049_1 | United Kingdom | United Kingdom | United Kingdom |
SO50050_1 | Australia | Australia | Australia |
SO50051_1 | Australia | Australia | Australia |
SO50052_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50053_1 | Germany | Germany | Germany |
SO50054_1 | France | France | France |
SO50055_1 | United Kingdom | United Kingdom | United Kingdom |
SO50056_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50057_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50122_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50123_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50124_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50125_1 | Australia | Australia | Australia |
SO50126_1 | Australia | Australia | Australia |
SO50127_1 | Australia | Australia | Australia |
SO50128_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50129_1 | United Kingdom | United Kingdom | United Kingdom |
SO50066_1 | Australia | Australia | Australia |
SO50067_1 | Australia | Australia | Australia |
SO50068_1 | Australia | Australia | Australia |
SO50069_1 | United Kingdom | United Kingdom | United Kingdom |
SO50070_1 | Germany | Germany | Germany |
SO50071_1 | United Kingdom | United Kingdom | United Kingdom |
SO50072_1 | Australia | Australia | Australia |
SO50073_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50074_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50075_1 | Australia | Australia | Australia |
SO50076_1 | Australia | Australia | Australia |
SO50077_1 | Australia | Australia | Australia |
SO50078_1 | Australia | Australia | Australia |
SO50079_1 | Australia | Australia | Australia |
SO50080_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50081_1 | France | France | France |
SO50082_1 | Germany | Germany | Germany |
SO50083_1 | France | France | France |
SO50084_1 | Germany | Germany | Germany |
SO50085_1 | Australia | Australia | Australia |
SO50086_1 | Australia | Australia | Australia |
SO50087_1 | Canada | Canada | Canada |
SO50088_1 | France | France | France |
SO50089_1 | France | France | France |
SO50090_1 | France | France | France |
SO50091_1 | France | France | France |
SO50092_1 | France | France | France |
SO50093_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50094_1 | Australia | Australia | Australia |
SO50095_1 | Australia | Australia | Australia |
SO50096_1 | United Kingdom | United Kingdom | United Kingdom |
SO50097_1 | France | France | France |
SO50098_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50099_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50100_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50101_1 | France | France | France |
SO50102_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50103_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50104_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50105_1 | Australia | Australia | Australia |
SO50106_1 | Australia | Australia | Australia |
SO50107_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50108_1 | United Kingdom | United Kingdom | United Kingdom |
SO50109_1 | France | France | France |
SO50110_1 | France | France | France |
SO50111_1 | Australia | Australia | Australia |
SO50112_1 | Australia | Australia | Australia |
SO50113_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50114_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50115_1 | Germany | Germany | Germany |
SO50116_1 | Germany | Germany | Germany |
SO50117_1 | Germany | Germany | Germany |
SO50118_1 | United Kingdom | United Kingdom | United Kingdom |
SO50119_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50120_1 | Australia | Australia | Australia |
SO50121_1 | Australia | Australia | Australia |
SO50186_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50187_1 | Australia | Australia | Australia |
SO50188_1 | Australia | Australia | Australia |
SO50323_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50324_1 | United Kingdom | United Kingdom | United Kingdom |
SO50325_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50326_1 | Canada | Canada | Canada |
SO50327_1 | United Kingdom | United Kingdom | United Kingdom |
SO48858_1 | France | France | France |
SO48859_1 | Germany | Germany | Germany |
SO48860_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48861_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48862_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48863_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48864_1 | Australia | Australia | Australia |
SO48865_1 | Australia | Australia | Australia |
SO48866_1 | Australia | Australia | Australia |
SO48867_1 | France | France | France |
SO48868_1 | France | France | France |
SO48869_1 | Australia | Australia | Australia |
SO48870_1 | Australia | Australia | Australia |
SO48871_1 | Canada | Canada | Canada |
SO48872_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48873_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48874_1 | Australia | Australia | Australia |
SO48875_1 | Australia | Australia | Australia |
SO48876_1 | Australia | Australia | Australia |
SO48877_1 | Australia | Australia | Australia |
SO48878_1 | United Kingdom | United Kingdom | United Kingdom |
SO48879_1 | United Kingdom | United Kingdom | United Kingdom |
SO48880_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48881_1 | Australia | Australia | Australia |
SO48882_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48883_1 | Australia | Australia | Australia |
SO48884_1 | Australia | Australia | Australia |
SO48885_1 | United Kingdom | United Kingdom | United Kingdom |
SO48886_1 | United Kingdom | United Kingdom | United Kingdom |
SO48887_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48888_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48889_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48890_1 | Australia | Australia | Australia |
SO48891_1 | Australia | Australia | Australia |
SO48892_1 | France | France | France |
SO48893_1 | United Kingdom | United Kingdom | United Kingdom |
SO48894_1 | Germany | Germany | Germany |
SO48895_1 | United Kingdom | United Kingdom | United Kingdom |
SO48896_1 | United Kingdom | United Kingdom | United Kingdom |
SO48897_1 | Germany | Germany | Germany |
SO48898_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48899_1 | Australia | Australia | Australia |
SO48900_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48901_1 | Australia | Australia | Australia |
SO48902_1 | Australia | Australia | Australia |
SO48903_1 | Australia | Australia | Australia |
SO48904_1 | United Kingdom | United Kingdom | United Kingdom |
SO48905_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48906_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48907_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48908_1 | Australia | Australia | Australia |
SO48909_1 | Australia | Australia | Australia |
SO48910_1 | Germany | Germany | Germany |
SO48911_1 | United Kingdom | United Kingdom | United Kingdom |
SO48912_1 | Germany | Germany | Germany |
SO48913_1 | Australia | Australia | Australia |
SO50384_1 | Australia | Australia | Australia |
SO50385_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50386_1 | Germany | Germany | Germany |
SO50387_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50388_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50389_1 | Germany | Germany | Germany |
SO50390_1 | United Kingdom | United Kingdom | United Kingdom |
SO50391_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50328_1 | France | France | France |
SO50329_1 | France | France | France |
SO50330_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50331_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50332_1 | Australia | Australia | Australia |
SO50333_1 | Australia | Australia | Australia |
SO50334_1 | Australia | Australia | Australia |
SO50335_1 | Australia | Australia | Australia |
SO50336_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50337_1 | Canada | Canada | Canada |
SO50338_1 | Germany | Germany | Germany |
SO50339_1 | United Kingdom | United Kingdom | United Kingdom |
SO50340_1 | France | France | France |
SO50341_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50342_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50343_1 | Canada | Canada | Canada |
SO50344_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50345_1 | Australia | Australia | Australia |
SO50346_1 | Australia | Australia | Australia |
SO50347_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50348_1 | Germany | Germany | Germany |
SO50349_1 | Germany | Germany | Germany |
SO50350_1 | United Kingdom | United Kingdom | United Kingdom |
SO50351_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50352_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50353_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50354_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50355_1 | Australia | Australia | Australia |
SO50356_1 | Australia | Australia | Australia |
Generated 2025-07-10 04:39:57.181 UTC