[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3233 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO48135_1 | Australia | Australia | Australia |
SO48136_1 | Australia | Australia | Australia |
SO48137_1 | Germany | Germany | Germany |
SO48138_1 | France | France | France |
SO48139_1 | Australia | Australia | Australia |
SO48140_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48141_1 | United Kingdom | United Kingdom | United Kingdom |
SO48142_1 | Germany | Germany | Germany |
SO48143_1 | Germany | Germany | Germany |
SO48144_1 | United Kingdom | United Kingdom | United Kingdom |
SO48145_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48146_1 | Australia | Australia | Australia |
SO48147_1 | Australia | Australia | Australia |
SO48148_1 | Germany | Germany | Germany |
SO48149_1 | Germany | Germany | Germany |
SO48150_1 | United Kingdom | United Kingdom | United Kingdom |
SO48151_1 | France | France | France |
SO48152_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48153_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48154_1 | Australia | Australia | Australia |
SO48155_1 | Australia | Australia | Australia |
SO48156_1 | Australia | Australia | Australia |
SO48157_1 | Australia | Australia | Australia |
SO48158_1 | Australia | Australia | Australia |
SO48465_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48466_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48467_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48468_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-12 21:17:11.581 UTC