[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8309 > < TAKE 224 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
224 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52550_1 | France | France | France |
SO52551_1 | France | France | France |
SO52551_2 | France | France | France |
SO52551_3 | France | France | France |
SO52577_4 | France | France | France |
SO52577_5 | France | France | France |
SO52577_6 | France | France | France |
SO52578_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52579_1 | Australia | Australia | Australia |
SO52579_2 | Australia | Australia | Australia |
SO52580_1 | Australia | Australia | Australia |
SO52580_2 | Australia | Australia | Australia |
SO52423_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52342_6 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52343_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52426_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52344_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52426_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52345_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52427_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52345_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52428_1 | Canada | Canada | Canada |
SO52346_1 | Canada | Canada | Canada |
SO52428_2 | Canada | Canada | Canada |
SO52346_2 | Canada | Canada | Canada |
SO52428_3 | Canada | Canada | Canada |
SO52347_1 | Canada | Canada | Canada |
SO52429_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52347_2 | Canada | Canada | Canada |
SO52429_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52348_1 | Canada | Canada | Canada |
SO52430_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52348_2 | Canada | Canada | Canada |
SO52430_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52349_1 | Canada | Canada | Canada |
SO52430_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52349_2 | Canada | Canada | Canada |
SO52431_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52350_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52350_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52351_1 | Canada | Canada | Canada |
SO52433_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52351_2 | Canada | Canada | Canada |
SO52433_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52352_1 | France | France | France |
SO52434_1 | Canada | Canada | Canada |
SO52352_2 | France | France | France |
SO52434_2 | Canada | Canada | Canada |
SO52353_1 | Germany | Germany | Germany |
SO52434_3 | Canada | Canada | Canada |
SO52353_2 | Germany | Germany | Germany |
SO52435_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52353_3 | Germany | Germany | Germany |
SO52435_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52354_1 | Germany | Germany | Germany |
SO52436_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52354_2 | Germany | Germany | Germany |
SO52436_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52354_3 | Germany | Germany | Germany |
SO52437_1 | United Kingdom | United Kingdom | United Kingdom |
SO52354_4 | Germany | Germany | Germany |
SO52437_2 | United Kingdom | United Kingdom | United Kingdom |
SO52355_1 | France | France | France |
SO52437_3 | United Kingdom | United Kingdom | United Kingdom |
SO52355_2 | France | France | France |
SO52438_1 | Germany | Germany | Germany |
SO52355_3 | France | France | France |
SO52439_1 | Germany | Germany | Germany |
SO52356_1 | Germany | Germany | Germany |
SO52439_2 | Germany | Germany | Germany |
SO52356_2 | Germany | Germany | Germany |
SO52440_1 | France | France | France |
SO52357_1 | France | France | France |
SO52440_2 | France | France | France |
SO52357_2 | France | France | France |
SO52441_1 | France | France | France |
SO52357_3 | France | France | France |
SO52442_1 | Germany | Germany | Germany |
SO52358_1 | Germany | Germany | Germany |
SO52443_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52358_2 | Germany | Germany | Germany |
SO52443_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52358_3 | Germany | Germany | Germany |
SO52443_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52359_1 | Canada | Canada | Canada |
SO52443_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52360_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52360_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52360_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52360_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52445_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52360_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52445_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52361_1 | Australia | Australia | Australia |
SO52445_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52361_2 | Australia | Australia | Australia |
SO52446_1 | Canada | Canada | Canada |
SO52361_3 | Australia | Australia | Australia |
SO52446_2 | Canada | Canada | Canada |
SO52361_4 | Australia | Australia | Australia |
SO52446_3 | Canada | Canada | Canada |
SO52362_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52363_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52363_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52364_1 | Germany | Germany | Germany |
SO52448_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52364_2 | Germany | Germany | Germany |
SO52448_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52605_2 | France | France | France |
SO52449_1 | Germany | Germany | Germany |
SO52606_1 | Germany | Germany | Germany |
SO52450_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52606_2 | Germany | Germany | Germany |
SO52450_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52607_1 | Canada | Canada | Canada |
SO52451_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52607_2 | Canada | Canada | Canada |
SO52451_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52607_3 | Canada | Canada | Canada |
SO52451_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52608_1 | United Kingdom | United Kingdom | United Kingdom |
SO52451_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52609_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52609_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52609_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52609_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52609_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52610_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52610_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52610_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52611_1 | Canada | Canada | Canada |
SO52611_2 | Canada | Canada | Canada |
SO52611_3 | Canada | Canada | Canada |
SO52612_1 | United Kingdom | United Kingdom | United Kingdom |
SO52612_2 | United Kingdom | United Kingdom | United Kingdom |
SO52612_3 | United Kingdom | United Kingdom | United Kingdom |
SO52612_4 | United Kingdom | United Kingdom | United Kingdom |
SO52613_1 | United Kingdom | United Kingdom | United Kingdom |
SO52613_2 | United Kingdom | United Kingdom | United Kingdom |
SO52613_3 | United Kingdom | United Kingdom | United Kingdom |
SO52613_4 | United Kingdom | United Kingdom | United Kingdom |
SO52614_1 | France | France | France |
SO52614_2 | France | France | France |
SO52614_3 | France | France | France |
SO52615_1 | France | France | France |
SO52615_2 | France | France | France |
SO52616_1 | United Kingdom | United Kingdom | United Kingdom |
SO52616_2 | United Kingdom | United Kingdom | United Kingdom |
SO52616_3 | United Kingdom | United Kingdom | United Kingdom |
SO52616_4 | United Kingdom | United Kingdom | United Kingdom |
SO52617_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52617_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52617_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52618_1 | Australia | Australia | Australia |
SO52618_2 | Australia | Australia | Australia |
SO52618_3 | Australia | Australia | Australia |
SO52619_1 | Australia | Australia | Australia |
SO52619_2 | Australia | Australia | Australia |
SO52620_1 | Australia | Australia | Australia |
SO52620_2 | Australia | Australia | Australia |
SO52620_3 | Australia | Australia | Australia |
SO52621_1 | Australia | Australia | Australia |
SO52622_1 | Australia | Australia | Australia |
SO52623_1 | Australia | Australia | Australia |
SO52624_1 | Australia | Australia | Australia |
SO52625_1 | France | France | France |
SO52626_1 | Canada | Canada | Canada |
SO52626_2 | Canada | Canada | Canada |
SO52626_3 | Canada | Canada | Canada |
SO52627_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52627_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52627_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52629_1 | Canada | Canada | Canada |
SO52629_2 | Canada | Canada | Canada |
SO52630_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52630_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52631_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52631_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52632_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52632_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52632_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52632_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52632_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52633_1 | Canada | Canada | Canada |
SO52633_2 | Canada | Canada | Canada |
SO52634_1 | Canada | Canada | Canada |
SO52634_2 | Canada | Canada | Canada |
SO52635_1 | Canada | Canada | Canada |
SO52635_2 | Canada | Canada | Canada |
SO52635_3 | Canada | Canada | Canada |
SO52636_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52636_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52637_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52638_1 | Canada | Canada | Canada |
SO52638_2 | Canada | Canada | Canada |
SO52638_3 | Canada | Canada | Canada |
SO52639_1 | Germany | Germany | Germany |
SO52639_2 | Germany | Germany | Germany |
SO52640_1 | United Kingdom | United Kingdom | United Kingdom |
SO52640_2 | United Kingdom | United Kingdom | United Kingdom |
SO52641_1 | United Kingdom | United Kingdom | United Kingdom |
SO52642_1 | Germany | Germany | Germany |
SO52642_2 | Germany | Germany | Germany |
Generated 2025-07-09 04:03:54.891 UTC