[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7434 > < TAKE 60 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
60 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52122_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52123_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52124_1 | United States, Northeast | United States, Northeast | United States, Northeast |
SO52124_2 | United States, Northeast | United States, Northeast | United States, Northeast |
SO52125_1 | Canada | Canada | Canada |
SO52125_2 | Canada | Canada | Canada |
SO52126_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52127_1 | Canada | Canada | Canada |
SO52127_2 | Canada | Canada | Canada |
SO52127_3 | Canada | Canada | Canada |
SO52128_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52128_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52129_1 | Canada | Canada | Canada |
SO52129_2 | Canada | Canada | Canada |
SO52129_3 | Canada | Canada | Canada |
SO52130_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52130_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52130_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52131_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52132_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52132_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52133_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52133_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52134_1 | United Kingdom | United Kingdom | United Kingdom |
SO52134_2 | United Kingdom | United Kingdom | United Kingdom |
SO52135_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52135_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52136_1 | France | France | France |
SO52136_2 | France | France | France |
SO52137_1 | Germany | Germany | Germany |
SO52137_2 | Germany | Germany | Germany |
SO52137_3 | Germany | Germany | Germany |
SO52138_1 | United Kingdom | United Kingdom | United Kingdom |
SO52139_1 | United Kingdom | United Kingdom | United Kingdom |
SO52139_2 | United Kingdom | United Kingdom | United Kingdom |
SO52139_3 | United Kingdom | United Kingdom | United Kingdom |
SO52140_1 | Germany | Germany | Germany |
SO52140_2 | Germany | Germany | Germany |
SO52140_3 | Germany | Germany | Germany |
SO52140_4 | Germany | Germany | Germany |
SO52141_1 | Germany | Germany | Germany |
SO52141_2 | Germany | Germany | Germany |
SO52142_1 | United Kingdom | United Kingdom | United Kingdom |
SO52143_1 | Germany | Germany | Germany |
SO52143_2 | Germany | Germany | Germany |
SO52143_3 | Germany | Germany | Germany |
SO52144_1 | Canada | Canada | Canada |
SO52200_1 | Canada | Canada | Canada |
SO52200_2 | Canada | Canada | Canada |
SO52201_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52201_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52201_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52202_1 | Canada | Canada | Canada |
SO52202_2 | Canada | Canada | Canada |
SO52202_3 | Canada | Canada | Canada |
SO52091_1 | Canada | Canada | Canada |
SO52091_2 | Canada | Canada | Canada |
SO52092_1 | Canada | Canada | Canada |
SO52093_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52094_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-13 23:05:05.028 UTC