[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4274 > < TAKE 30 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
30 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49010_1 | Australia | Australia | Australia |
SO49569_1 | France | France | France |
SO49011_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49570_1 | Australia | Australia | Australia |
SO49012_1 | Germany | Germany | Germany |
SO49571_1 | Australia | Australia | Australia |
SO49013_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49572_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49014_1 | Australia | Australia | Australia |
SO49573_1 | Australia | Australia | Australia |
SO49015_1 | Australia | Australia | Australia |
SO49574_1 | Australia | Australia | Australia |
SO49016_1 | Australia | Australia | Australia |
SO49575_1 | France | France | France |
SO49017_1 | United Kingdom | United Kingdom | United Kingdom |
SO49576_1 | Germany | Germany | Germany |
SO49018_1 | United Kingdom | United Kingdom | United Kingdom |
SO49577_1 | Germany | Germany | Germany |
SO49019_1 | United Kingdom | United Kingdom | United Kingdom |
SO49578_1 | Germany | Germany | Germany |
SO49020_1 | Germany | Germany | Germany |
SO49579_1 | Australia | Australia | Australia |
SO49021_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49580_1 | Australia | Australia | Australia |
SO49022_1 | Australia | Australia | Australia |
SO49581_1 | United Kingdom | United Kingdom | United Kingdom |
SO49023_1 | Australia | Australia | Australia |
SO49582_1 | Germany | Germany | Germany |
SO49024_1 | Australia | Australia | Australia |
SO49583_1 | France | France | France |
Generated 2025-07-07 14:01:50.836 UTC