[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4709 > < TAKE 30 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
30 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO50166_1 | United Kingdom | United Kingdom | United Kingdom |
SO50167_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50168_1 | Australia | Australia | Australia |
SO50169_1 | Australia | Australia | Australia |
SO50170_1 | Australia | Australia | Australia |
SO50171_1 | France | France | France |
SO50172_1 | France | France | France |
SO50173_1 | Australia | Australia | Australia |
SO50174_1 | Australia | Australia | Australia |
SO50175_1 | Australia | Australia | Australia |
SO50176_1 | France | France | France |
SO50177_1 | Australia | Australia | Australia |
SO50178_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50179_1 | Germany | Germany | Germany |
SO50180_1 | Germany | Germany | Germany |
SO50181_1 | Germany | Germany | Germany |
SO50182_1 | United Kingdom | United Kingdom | United Kingdom |
SO50183_1 | Germany | Germany | Germany |
SO50184_1 | France | France | France |
SO50185_1 | Germany | Germany | Germany |
SO50448_1 | Australia | Australia | Australia |
SO50449_1 | Australia | Australia | Australia |
SO50450_1 | France | France | France |
SO50451_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50452_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50453_1 | France | France | France |
SO50454_1 | United Kingdom | United Kingdom | United Kingdom |
SO50455_1 | France | France | France |
SO50328_1 | France | France | France |
SO50329_1 | France | France | France |
Generated 2025-07-06 11:49:11.783 UTC