[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 |
---|---|---|---|
SO46698_1 | Australia | Australia | Australia |
SO46699_1 | Australia | Australia | Australia |
SO46700_1 | France | France | France |
SO46701_1 | Germany | Germany | Germany |
SO46702_1 | Germany | Germany | Germany |
SO46703_1 | United Kingdom | United Kingdom | United Kingdom |
SO46704_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46705_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46706_1 | Canada | Canada | Canada |
SO46707_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46708_1 | Australia | Australia | Australia |
SO46709_1 | United Kingdom | United Kingdom | United Kingdom |
SO46710_1 | Germany | Germany | Germany |
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 |
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 |
SO46775_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46776_1 | Australia | Australia | Australia |
SO46777_1 | United Kingdom | United Kingdom | United Kingdom |
SO46778_1 | United Kingdom | United Kingdom | United Kingdom |
SO46779_1 | United Kingdom | United Kingdom | United Kingdom |
SO46780_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46781_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46782_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46783_1 | France | France | France |
SO46784_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46785_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46786_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46787_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46788_1 | Australia | Australia | Australia |
SO46789_1 | France | France | France |
SO46790_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46791_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46792_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46793_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46794_1 | Canada | Canada | Canada |
SO46795_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46796_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46797_1 | Australia | Australia | Australia |
SO46798_1 | Australia | Australia | Australia |
SO46799_1 | France | France | France |
SO46800_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46801_1 | Canada | Canada | Canada |
SO46802_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46803_1 | France | France | France |
SO46804_1 | France | France | France |
SO46805_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46806_1 | Australia | Australia | Australia |
SO47074_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47075_1 | Australia | Australia | Australia |
SO47076_1 | Australia | Australia | Australia |
SO47077_1 | United Kingdom | United Kingdom | United Kingdom |
SO47078_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47079_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47080_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47081_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46815_1 | Canada | Canada | Canada |
SO46816_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46817_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46818_1 | Australia | Australia | Australia |
SO46819_1 | Australia | Australia | Australia |
SO46820_1 | France | France | France |
SO46821_1 | Canada | Canada | Canada |
SO46822_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46823_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46824_1 | Australia | Australia | Australia |
SO46825_1 | Australia | Australia | Australia |
SO46826_1 | Australia | Australia | Australia |
SO46827_1 | France | France | France |
SO46828_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46829_1 | Canada | Canada | Canada |
SO46830_1 | Germany | Germany | Germany |
SO46831_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46832_1 | Canada | Canada | Canada |
SO46833_1 | Australia | Australia | Australia |
SO46834_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46835_1 | France | France | France |
SO46836_1 | France | France | France |
SO46837_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46838_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46839_1 | Canada | Canada | Canada |
SO46840_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46841_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46842_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46843_1 | Australia | Australia | Australia |
SO46844_1 | Australia | Australia | Australia |
SO46845_1 | United Kingdom | United Kingdom | United Kingdom |
SO46846_1 | France | France | France |
SO46847_1 | France | France | France |
SO46848_1 | United Kingdom | United Kingdom | United Kingdom |
SO46849_1 | Canada | Canada | Canada |
SO46850_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46851_1 | Canada | Canada | Canada |
SO46852_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46853_1 | Australia | Australia | Australia |
SO46854_1 | Australia | Australia | Australia |
SO46855_1 | Germany | Germany | Germany |
SO46856_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46857_1 | United States, Northwest | United States, Northwest | United States, Northwest |
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 |
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 |
SO47144_1 | Australia | Australia | Australia |
SO47145_1 | Australia | Australia | Australia |
SO45950_1 | Australia | Australia | Australia |
SO45951_1 | Australia | Australia | Australia |
SO45952_1 | Australia | Australia | Australia |
SO45953_1 | Canada | Canada | Canada |
SO45954_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45955_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45956_1 | Australia | Australia | Australia |
SO45957_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45958_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45959_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45960_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45961_1 | France | France | France |
SO45962_1 | Australia | Australia | Australia |
SO45963_1 | Australia | Australia | Australia |
SO45964_1 | Australia | Australia | Australia |
SO45965_1 | Australia | Australia | Australia |
SO45966_1 | Australia | Australia | Australia |
SO45967_1 | Germany | Germany | Germany |
SO45968_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45969_1 | Australia | Australia | Australia |
SO45970_1 | Australia | Australia | Australia |
SO45971_1 | Germany | Germany | Germany |
SO45972_1 | Germany | Germany | Germany |
SO45973_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46123_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46124_1 | Australia | Australia | Australia |
SO46125_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46126_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46127_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46128_1 | Germany | Germany | Germany |
SO46129_1 | Australia | Australia | Australia |
SO46130_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46131_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46132_1 | Canada | Canada | Canada |
SO46133_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46134_1 | Australia | Australia | Australia |
SO46135_1 | Australia | Australia | Australia |
SO46136_1 | Australia | Australia | Australia |
SO46137_1 | Australia | Australia | Australia |
SO46138_1 | France | France | France |
SO46139_1 | Australia | Australia | Australia |
SO46140_1 | Australia | Australia | Australia |
SO46141_1 | Germany | Germany | Germany |
SO46142_1 | Canada | Canada | Canada |
SO46143_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46144_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46145_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46146_1 | Germany | Germany | Germany |
SO46147_1 | Germany | Germany | Germany |
SO46148_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46149_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46150_1 | United Kingdom | United Kingdom | United Kingdom |
SO46151_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46152_1 | Australia | Australia | Australia |
SO46153_1 | Australia | Australia | Australia |
SO46154_1 | Australia | Australia | Australia |
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 |
SO47082_1 | United States, Southeast | United States, Southeast | United States, Southeast |
SO47083_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47084_1 | Australia | Australia | Australia |
SO47085_1 | United Kingdom | United Kingdom | United Kingdom |
SO47086_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47087_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47088_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47089_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47090_1 | Australia | Australia | Australia |
SO47091_1 | France | France | France |
SO47092_1 | Canada | Canada | Canada |
SO47093_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47094_1 | Germany | Germany | Germany |
SO47095_1 | Canada | Canada | Canada |
SO47096_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47097_1 | Australia | Australia | Australia |
SO47098_1 | Australia | Australia | Australia |
SO47099_1 | Australia | Australia | Australia |
SO47100_1 | United Kingdom | United Kingdom | United Kingdom |
SO47101_1 | United Kingdom | United Kingdom | United Kingdom |
SO47102_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47103_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47104_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47105_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47106_1 | Canada | Canada | Canada |
SO47107_1 | United Kingdom | United Kingdom | United Kingdom |
SO47108_1 | France | France | France |
Generated 2025-07-10 21:32:20.112 UTC