[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3474 > < TAKE 30 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
30 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO48682_1 | Australia | Australia | Australia |
SO48683_1 | France | France | France |
SO48684_1 | Germany | Germany | Germany |
SO48685_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48686_1 | Canada | Canada | Canada |
SO48687_1 | United Kingdom | United Kingdom | United Kingdom |
SO48688_1 | Australia | Australia | Australia |
SO48689_1 | Australia | Australia | Australia |
SO48690_1 | Australia | Australia | Australia |
SO48691_1 | Australia | Australia | Australia |
SO48692_1 | Germany | Germany | Germany |
SO48693_1 | Canada | Canada | Canada |
SO48694_1 | United Kingdom | United Kingdom | United Kingdom |
SO48695_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48696_1 | Australia | Australia | Australia |
SO48697_1 | Australia | Australia | Australia |
SO48698_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48699_1 | Australia | Australia | Australia |
SO48700_1 | Australia | Australia | Australia |
SO48701_1 | Australia | Australia | Australia |
SO48702_1 | United Kingdom | United Kingdom | United Kingdom |
SO48703_1 | France | France | France |
SO48704_1 | Germany | Germany | Germany |
SO48705_1 | France | France | France |
SO48706_1 | United Kingdom | United Kingdom | United Kingdom |
SO48707_1 | France | France | France |
SO48708_1 | Germany | Germany | Germany |
SO48709_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48710_1 | United Kingdom | United Kingdom | United Kingdom |
SO48711_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-08 12:13:35.600 UTC