[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5571 > < TAKE 30 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
30 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51225_1 | United Kingdom | United Kingdom | United Kingdom |
SO51225_2 | United Kingdom | United Kingdom | United Kingdom |
SO51225_3 | United Kingdom | United Kingdom | United Kingdom |
SO51226_1 | United Kingdom | United Kingdom | United Kingdom |
SO51226_2 | United Kingdom | United Kingdom | United Kingdom |
SO51227_1 | Germany | Germany | Germany |
SO51227_2 | Germany | Germany | Germany |
SO51227_3 | Germany | Germany | Germany |
SO51228_1 | France | France | France |
SO51228_2 | France | France | France |
SO51228_3 | France | France | France |
SO51228_4 | France | France | France |
SO51228_5 | France | France | France |
SO51229_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51232_1 | United Kingdom | United Kingdom | United Kingdom |
SO51232_2 | United Kingdom | United Kingdom | United Kingdom |
SO51233_1 | Australia | Australia | Australia |
SO51234_1 | Australia | Australia | Australia |
SO51234_2 | Australia | Australia | Australia |
SO51235_1 | Australia | Australia | Australia |
SO51236_1 | Australia | Australia | Australia |
SO51237_1 | Australia | Australia | Australia |
SO51237_2 | Australia | Australia | Australia |
SO51237_3 | Australia | Australia | Australia |
Generated 2025-07-08 03:37:59.176 UTC