[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2756 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47580_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47581_1 | Canada | Canada | Canada |
SO47582_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47583_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47584_1 | France | France | France |
SO47585_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47586_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47587_1 | Australia | Australia | Australia |
SO47588_1 | United Kingdom | United Kingdom | United Kingdom |
SO47589_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47590_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47591_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47592_1 | Australia | Australia | Australia |
SO47593_1 | Australia | Australia | Australia |
SO47594_1 | Australia | Australia | Australia |
SO47595_1 | France | France | France |
SO47596_1 | Germany | Germany | Germany |
SO47597_1 | Canada | Canada | Canada |
SO47598_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47599_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47600_1 | France | France | France |
SO47738_1 | Australia | Australia | Australia |
SO47739_1 | United Kingdom | United Kingdom | United Kingdom |
SO47740_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47741_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47742_1 | Australia | Australia | Australia |
SO47743_1 | Australia | Australia | Australia |
SO47744_1 | Australia | Australia | Australia |
SO47745_1 | Australia | Australia | Australia |
SO47746_1 | Australia | Australia | Australia |
SO47747_1 | Germany | Germany | Germany |
SO47748_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47749_1 | Australia | Australia | Australia |
SO47750_1 | Australia | Australia | Australia |
SO47751_1 | Australia | Australia | Australia |
SO47752_1 | Australia | Australia | Australia |
SO47753_1 | Australia | Australia | Australia |
SO47754_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47755_1 | France | France | France |
SO47756_1 | United Kingdom | United Kingdom | United Kingdom |
SO47757_1 | United Kingdom | United Kingdom | United Kingdom |
SO47758_1 | United Kingdom | United Kingdom | United Kingdom |
SO47759_1 | France | France | France |
SO47760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47761_1 | Germany | Germany | Germany |
SO47762_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47763_1 | Australia | Australia | Australia |
SO47764_1 | France | France | France |
SO47765_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47766_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47767_1 | Australia | Australia | Australia |
SO47768_1 | Australia | Australia | Australia |
SO47769_1 | Australia | Australia | Australia |
SO47770_1 | Australia | Australia | Australia |
SO47771_1 | Australia | Australia | Australia |
SO47772_1 | Australia | Australia | Australia |
SO47773_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47774_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47775_1 | Australia | Australia | Australia |
SO47776_1 | Australia | Australia | Australia |
SO47777_1 | Australia | Australia | Australia |
SO47609_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47610_1 | Canada | Canada | Canada |
SO47611_1 | Australia | Australia | Australia |
SO47612_1 | United Kingdom | United Kingdom | United Kingdom |
SO47613_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47614_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47615_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47616_1 | Australia | Australia | Australia |
SO47617_1 | Australia | Australia | Australia |
SO47618_1 | Australia | Australia | Australia |
SO47619_1 | Australia | Australia | Australia |
SO47620_1 | United Kingdom | United Kingdom | United Kingdom |
SO47621_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47622_1 | United Kingdom | United Kingdom | United Kingdom |
SO47623_1 | Australia | Australia | Australia |
SO47624_1 | Australia | Australia | Australia |
SO47625_1 | Australia | Australia | Australia |
SO47626_1 | Australia | Australia | Australia |
SO47627_1 | United Kingdom | United Kingdom | United Kingdom |
SO47628_1 | United Kingdom | United Kingdom | United Kingdom |
SO47629_1 | Germany | Germany | Germany |
SO47630_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47631_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47632_1 | Canada | Canada | Canada |
SO47633_1 | Australia | Australia | Australia |
SO47634_1 | Germany | Germany | Germany |
SO47635_1 | United Kingdom | United Kingdom | United Kingdom |
SO47636_1 | Australia | Australia | Australia |
SO47637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47638_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47639_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47640_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47641_1 | Canada | Canada | Canada |
SO47642_1 | France | France | France |
SO47643_1 | United Kingdom | United Kingdom | United Kingdom |
SO47644_1 | Germany | Germany | Germany |
SO47645_1 | France | France | France |
SO47646_1 | Canada | Canada | Canada |
SO47647_1 | Australia | Australia | Australia |
SO47648_1 | United Kingdom | United Kingdom | United Kingdom |
SO47649_1 | United Kingdom | United Kingdom | United Kingdom |
SO47650_1 | United Kingdom | United Kingdom | United Kingdom |
SO47651_1 | Canada | Canada | Canada |
SO47652_1 | United Kingdom | United Kingdom | United Kingdom |
SO47653_1 | Germany | Germany | Germany |
SO47654_1 | Australia | Australia | Australia |
SO47655_1 | Australia | Australia | Australia |
SO47656_1 | Australia | Australia | Australia |
SO47657_1 | Australia | Australia | Australia |
SO47731_1 | United Kingdom | United Kingdom | United Kingdom |
SO47732_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47733_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47734_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47735_1 | Canada | Canada | Canada |
SO47736_1 | Australia | Australia | Australia |
SO47737_1 | Australia | Australia | Australia |
SO47834_1 | Australia | Australia | Australia |
SO47835_1 | Australia | Australia | Australia |
SO47836_1 | France | France | France |
SO47837_1 | United Kingdom | United Kingdom | United Kingdom |
SO47838_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47839_1 | United Kingdom | United Kingdom | United Kingdom |
SO47840_1 | Germany | Germany | Germany |
SO47841_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47778_1 | United Kingdom | United Kingdom | United Kingdom |
SO47779_1 | Germany | Germany | Germany |
SO47780_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47781_1 | Canada | Canada | Canada |
SO47782_1 | Australia | Australia | Australia |
SO47783_1 | Australia | Australia | Australia |
SO47784_1 | Australia | Australia | Australia |
SO47785_1 | France | France | France |
SO47786_1 | France | France | France |
SO47787_1 | United Kingdom | United Kingdom | United Kingdom |
SO47788_1 | United Kingdom | United Kingdom | United Kingdom |
SO47789_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47790_1 | Australia | Australia | Australia |
SO47791_1 | Australia | Australia | Australia |
SO47792_1 | Germany | Germany | Germany |
SO47793_1 | France | France | France |
SO47794_1 | Canada | Canada | Canada |
SO47795_1 | Australia | Australia | Australia |
SO47796_1 | Australia | Australia | Australia |
SO47797_1 | Australia | Australia | Australia |
SO47798_1 | Australia | Australia | Australia |
SO47799_1 | United Kingdom | United Kingdom | United Kingdom |
SO47800_1 | France | France | France |
SO47801_1 | Germany | Germany | Germany |
SO47802_1 | United Kingdom | United Kingdom | United Kingdom |
SO47803_1 | Australia | Australia | Australia |
SO47804_1 | Australia | Australia | Australia |
SO47805_1 | Australia | Australia | Australia |
SO47806_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47807_1 | United Kingdom | United Kingdom | United Kingdom |
SO47808_1 | Australia | Australia | Australia |
SO47809_1 | Australia | Australia | Australia |
SO47810_1 | Australia | Australia | Australia |
SO47811_1 | United Kingdom | United Kingdom | United Kingdom |
SO47812_1 | Germany | Germany | Germany |
SO47813_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47814_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47815_1 | Australia | Australia | Australia |
SO47816_1 | Australia | Australia | Australia |
SO47817_1 | Australia | Australia | Australia |
SO47818_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47819_1 | Australia | Australia | Australia |
SO47820_1 | Australia | Australia | Australia |
SO47821_1 | Australia | Australia | Australia |
SO47822_1 | Australia | Australia | Australia |
SO47823_1 | Australia | Australia | Australia |
SO47824_1 | Germany | Germany | Germany |
SO47825_1 | Germany | Germany | Germany |
SO47826_1 | Australia | Australia | Australia |
SO47827_1 | Australia | Australia | Australia |
SO47828_1 | Australia | Australia | Australia |
SO47829_1 | Australia | Australia | Australia |
SO47830_1 | United Kingdom | United Kingdom | United Kingdom |
SO47831_1 | United Kingdom | United Kingdom | United Kingdom |
SO47832_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47833_1 | Australia | Australia | Australia |
SO47898_1 | France | France | France |
SO47899_1 | Australia | Australia | Australia |
SO47900_1 | Australia | Australia | Australia |
SO47901_1 | Australia | Australia | Australia |
SO47902_1 | Australia | Australia | Australia |
SO47903_1 | France | France | France |
SO47904_1 | United Kingdom | United Kingdom | United Kingdom |
SO47905_1 | Canada | Canada | Canada |
SO47842_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47843_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47844_1 | Australia | Australia | Australia |
SO47845_1 | Germany | Germany | Germany |
SO47846_1 | France | France | France |
SO47847_1 | Germany | Germany | Germany |
SO47848_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47849_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47850_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47851_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47852_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47853_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47854_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47855_1 | Australia | Australia | Australia |
SO47856_1 | Australia | Australia | Australia |
SO47857_1 | Australia | Australia | Australia |
SO47858_1 | United Kingdom | United Kingdom | United Kingdom |
SO47859_1 | France | France | France |
SO47860_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47861_1 | Canada | Canada | Canada |
SO47862_1 | Australia | Australia | Australia |
SO47863_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47864_1 | Australia | Australia | Australia |
SO47865_1 | Australia | Australia | Australia |
SO47866_1 | Australia | Australia | Australia |
SO47867_1 | Australia | Australia | Australia |
SO47868_1 | Australia | Australia | Australia |
SO47869_1 | Australia | Australia | Australia |
SO47870_1 | United Kingdom | United Kingdom | United Kingdom |
SO47871_1 | France | France | France |
SO47872_1 | France | France | France |
SO47873_1 | Canada | Canada | Canada |
SO47874_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47875_1 | Canada | Canada | Canada |
SO47876_1 | United Kingdom | United Kingdom | United Kingdom |
SO47877_1 | United Kingdom | United Kingdom | United Kingdom |
SO47878_1 | Australia | Australia | Australia |
SO47879_1 | Germany | Germany | Germany |
SO47880_1 | France | France | France |
SO47881_1 | United Kingdom | United Kingdom | United Kingdom |
SO47882_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47883_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47884_1 | Australia | Australia | Australia |
SO47885_1 | Australia | Australia | Australia |
SO47886_1 | Australia | Australia | Australia |
SO47887_1 | Australia | Australia | Australia |
SO47888_1 | Australia | Australia | Australia |
SO47889_1 | United Kingdom | United Kingdom | United Kingdom |
SO47890_1 | Germany | Germany | Germany |
SO47891_1 | Germany | Germany | Germany |
SO47892_1 | Canada | Canada | Canada |
SO47893_1 | Canada | Canada | Canada |
SO47894_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47895_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47896_1 | France | France | France |
SO47897_1 | United Kingdom | United Kingdom | United Kingdom |
SO48095_1 | Germany | Germany | Germany |
SO48096_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48097_1 | Australia | Australia | Australia |
Generated 2025-07-04 10:20:12.797 UTC