[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 9625 > < TAKE 62 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
62 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO53049_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53049_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53050_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53050_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53050_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53051_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53051_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO53052_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53052_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53052_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53053_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53053_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53054_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53054_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53054_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53054_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53055_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53055_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53055_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53055_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53056_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53056_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53056_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53056_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53057_1 | Germany | Germany | Germany |
SO53057_2 | Germany | Germany | Germany |
SO53058_1 | Germany | Germany | Germany |
SO53058_2 | Germany | Germany | Germany |
SO53058_3 | Germany | Germany | Germany |
SO53058_4 | Germany | Germany | Germany |
SO53059_1 | Australia | Australia | Australia |
SO53059_2 | Australia | Australia | Australia |
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 |
SO52871_2 | United Kingdom | United Kingdom | United Kingdom |
SO52872_1 | United Kingdom | United Kingdom | United Kingdom |
SO52872_2 | United Kingdom | United Kingdom | United Kingdom |
SO52872_3 | United Kingdom | United Kingdom | United Kingdom |
SO52873_1 | Canada | Canada | Canada |
SO52873_2 | Canada | Canada | Canada |
SO52873_3 | Canada | Canada | Canada |
SO52874_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52875_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52875_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52876_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52876_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52876_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52877_1 | Australia | Australia | Australia |
SO52877_2 | Australia | Australia | Australia |
SO52877_3 | Australia | Australia | Australia |
SO52877_4 | Australia | Australia | Australia |
SO52878_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52878_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52879_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52880_1 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-05 08:24:20.301 UTC