[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 9656 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO53036_3 | Germany | Germany | Germany |
SO53116_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53116_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53116_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53117_1 | Canada | Canada | Canada |
SO53117_2 | Canada | Canada | Canada |
SO53117_3 | Canada | Canada | Canada |
SO53118_1 | Canada | Canada | Canada |
SO53118_2 | Canada | Canada | Canada |
SO53040_3 | United Kingdom | United Kingdom | United Kingdom |
SO53041_1 | France | France | France |
SO53041_2 | France | France | France |
SO53041_3 | France | France | France |
SO53042_1 | Canada | Canada | Canada |
SO53042_2 | Canada | Canada | Canada |
SO53042_3 | Canada | Canada | Canada |
SO53043_1 | Canada | Canada | Canada |
SO53043_2 | Canada | Canada | Canada |
SO53044_1 | United Kingdom | United Kingdom | United Kingdom |
SO53045_1 | Canada | Canada | Canada |
SO53045_2 | Canada | Canada | Canada |
SO53045_3 | Canada | Canada | Canada |
SO53046_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53046_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53047_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53047_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53047_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53047_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53048_1 | Canada | Canada | Canada |
SO53048_2 | Canada | Canada | Canada |
SO53048_3 | Canada | Canada | Canada |
Generated 2025-07-06 07:03:01.156 UTC