[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 |
SO53119_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53120_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53120_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53120_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53120_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53121_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53121_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53122_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53122_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53122_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53122_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53123_1 | Australia | Australia | Australia |
SO53123_2 | Australia | Australia | Australia |
SO53124_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53124_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53124_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53125_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53125_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53125_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53125_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO53126_1 | Australia | Australia | Australia |
SO53127_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-04 17:29:52.875 UTC