[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4304 > < TAKE 30 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
30 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49679_1 | Australia | Australia | Australia |
SO49744_1 | Germany | Germany | Germany |
SO49680_1 | United Kingdom | United Kingdom | United Kingdom |
SO49745_1 | United Kingdom | United Kingdom | United Kingdom |
SO49681_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49746_1 | France | France | France |
SO49682_1 | Canada | Canada | Canada |
SO49747_1 | Germany | Germany | Germany |
SO49683_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49748_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49684_1 | Australia | Australia | Australia |
SO49749_1 | Australia | Australia | Australia |
SO49685_1 | United Kingdom | United Kingdom | United Kingdom |
SO49750_1 | Australia | Australia | Australia |
SO49686_1 | France | France | France |
SO49751_1 | United Kingdom | United Kingdom | United Kingdom |
SO49687_1 | France | France | France |
SO49752_1 | France | France | France |
SO49688_1 | United Kingdom | United Kingdom | United Kingdom |
SO49753_1 | Australia | Australia | Australia |
SO49689_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49754_1 | Australia | Australia | Australia |
SO49690_1 | Australia | Australia | Australia |
SO49755_1 | Australia | Australia | Australia |
SO49691_1 | Australia | Australia | Australia |
SO49756_1 | Australia | Australia | Australia |
SO49692_1 | United Kingdom | United Kingdom | United Kingdom |
SO49757_1 | United Kingdom | United Kingdom | United Kingdom |
SO49693_1 | Germany | Germany | Germany |
SO49758_1 | France | France | France |
Generated 2025-07-07 19:09:44.365 UTC