[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8000 > < TAKE 125 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
125 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52451_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52318_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52319_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52320_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52320_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52321_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52322_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52323_1 | Australia | Australia | Australia |
SO52323_2 | Australia | Australia | Australia |
SO52324_1 | Australia | Australia | Australia |
SO52324_2 | Australia | Australia | Australia |
SO52324_3 | Australia | Australia | Australia |
SO52324_4 | Australia | Australia | Australia |
SO52325_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52325_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52326_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52326_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52327_1 | France | France | France |
SO52327_2 | France | France | France |
SO52327_3 | France | France | France |
SO52327_4 | France | France | France |
SO52328_1 | Australia | Australia | Australia |
SO52328_2 | Australia | Australia | Australia |
SO52329_1 | France | France | France |
SO52329_2 | France | France | France |
SO52329_3 | France | France | France |
SO52330_1 | Australia | Australia | Australia |
SO52330_2 | Australia | Australia | Australia |
SO52331_1 | Australia | Australia | Australia |
SO52331_2 | Australia | Australia | Australia |
SO52332_1 | Australia | Australia | Australia |
SO52332_2 | Australia | Australia | Australia |
SO52333_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52334_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52334_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52335_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52335_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52336_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52336_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52337_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52337_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52337_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52338_1 | Canada | Canada | Canada |
SO52338_2 | Canada | Canada | Canada |
SO52338_3 | Canada | Canada | Canada |
SO52339_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52393_2 | United Kingdom | United Kingdom | United Kingdom |
SO52394_1 | United Kingdom | United Kingdom | United Kingdom |
SO52394_2 | United Kingdom | United Kingdom | United Kingdom |
SO52395_1 | France | France | France |
SO52396_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52396_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52423_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52424_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52425_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52426_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52427_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52428_1 | Canada | Canada | Canada |
SO52428_2 | Canada | Canada | Canada |
SO52428_3 | Canada | Canada | Canada |
SO52429_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52429_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52430_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52430_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52430_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52431_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52432_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52433_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52433_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52434_1 | Canada | Canada | Canada |
SO52434_2 | Canada | Canada | Canada |
SO52434_3 | Canada | Canada | Canada |
SO52435_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52435_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52436_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52436_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52437_1 | United Kingdom | United Kingdom | United Kingdom |
SO52437_2 | United Kingdom | United Kingdom | United Kingdom |
SO52437_3 | United Kingdom | United Kingdom | United Kingdom |
SO52438_1 | Germany | Germany | Germany |
SO52439_1 | Germany | Germany | Germany |
SO52439_2 | Germany | Germany | Germany |
SO52440_1 | France | France | France |
SO52440_2 | France | France | France |
SO52441_1 | France | France | France |
SO52442_1 | Germany | Germany | Germany |
SO52443_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52443_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52444_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52445_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52445_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52445_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52446_1 | Canada | Canada | Canada |
SO52446_2 | Canada | Canada | Canada |
SO52446_3 | Canada | Canada | Canada |
SO52447_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52447_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52448_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52470_4 | United Kingdom | United Kingdom | United Kingdom |
SO52471_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52471_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52471_3 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-04-06 22:31:23.971 UTC