[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3491 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47567_1 | Australia | Australia | Australia |
SO48591_1 | France | France | France |
SO48527_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47568_1 | Australia | Australia | Australia |
SO48592_1 | Germany | Germany | Germany |
SO48528_1 | Australia | Australia | Australia |
SO48721_1 | Australia | Australia | Australia |
SO48657_1 | France | France | France |
SO48593_1 | United Kingdom | United Kingdom | United Kingdom |
SO48722_1 | Australia | Australia | Australia |
SO48658_1 | Germany | Germany | Germany |
SO48594_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48723_1 | France | France | France |
SO48659_1 | France | France | France |
SO48595_1 | Australia | Australia | Australia |
SO48724_1 | Germany | Germany | Germany |
SO48660_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48596_1 | Australia | Australia | Australia |
SO48725_1 | United Kingdom | United Kingdom | United Kingdom |
SO48661_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48597_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48726_1 | Australia | Australia | Australia |
SO48662_1 | Australia | Australia | Australia |
SO48598_1 | Australia | Australia | Australia |
SO48727_1 | Australia | Australia | Australia |
SO48663_1 | Australia | Australia | Australia |
SO48599_1 | France | France | France |
SO48728_1 | Australia | Australia | Australia |
Generated 2025-07-08 09:41:54.008 UTC