[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3941 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49272_1 | Australia | Australia | Australia |
SO48948_1 | Australia | Australia | Australia |
SO49273_1 | Canada | Canada | Canada |
SO48949_1 | Australia | Australia | Australia |
SO49274_1 | Canada | Canada | Canada |
SO48950_1 | United Kingdom | United Kingdom | United Kingdom |
SO49275_1 | Australia | Australia | Australia |
SO48951_1 | France | France | France |
SO49276_1 | United Kingdom | United Kingdom | United Kingdom |
SO48952_1 | France | France | France |
SO49277_1 | United Kingdom | United Kingdom | United Kingdom |
SO48953_1 | Australia | Australia | Australia |
SO49278_1 | Australia | Australia | Australia |
SO48954_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49279_1 | Australia | Australia | Australia |
SO48955_1 | Australia | Australia | Australia |
SO49280_1 | United Kingdom | United Kingdom | United Kingdom |
SO48956_1 | Australia | Australia | Australia |
SO49281_1 | France | France | France |
SO48957_1 | Germany | Germany | Germany |
SO49282_1 | Australia | Australia | Australia |
SO48958_1 | Australia | Australia | Australia |
SO49283_1 | Australia | Australia | Australia |
SO48959_1 | Australia | Australia | Australia |
SO49284_1 | Australia | Australia | Australia |
SO48960_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49285_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48961_1 | Australia | Australia | Australia |
Generated 2025-07-15 20:39:04.097 UTC