[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4282 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49572_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49637_1 | United Kingdom | United Kingdom | United Kingdom |
SO49573_1 | Australia | Australia | Australia |
SO49638_1 | Germany | Germany | Germany |
SO49574_1 | Australia | Australia | Australia |
SO49639_1 | France | France | France |
SO49575_1 | France | France | France |
SO49640_1 | Germany | Germany | Germany |
SO49576_1 | Germany | Germany | Germany |
SO49641_1 | Australia | Australia | Australia |
SO49577_1 | Germany | Germany | Germany |
SO49642_1 | Australia | Australia | Australia |
SO49578_1 | Germany | Germany | Germany |
SO49643_1 | Australia | Australia | Australia |
SO49579_1 | Australia | Australia | Australia |
SO49644_1 | Australia | Australia | Australia |
SO49580_1 | Australia | Australia | Australia |
SO49645_1 | France | France | France |
SO49581_1 | United Kingdom | United Kingdom | United Kingdom |
SO49646_1 | France | France | France |
SO49582_1 | Germany | Germany | Germany |
SO49647_1 | Germany | Germany | Germany |
SO49583_1 | France | France | France |
SO49648_1 | United Kingdom | United Kingdom | United Kingdom |
SO49584_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49649_1 | United Kingdom | United Kingdom | United Kingdom |
SO49585_1 | United Kingdom | United Kingdom | United Kingdom |
SO49650_1 | United Kingdom | United Kingdom | United Kingdom |
SO49586_1 | Germany | Germany | Germany |
SO49651_1 | Australia | Australia | Australia |
SO49587_1 | Australia | Australia | Australia |
Generated 2025-07-08 03:49:51.239 UTC