[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5668 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51267_1 | Australia | Australia | Australia |
SO51341_2 | France | France | France |
SO51315_2 | Australia | Australia | Australia |
SO51267_2 | Australia | Australia | Australia |
SO51341_3 | France | France | France |
SO51315_3 | Australia | Australia | Australia |
SO51267_3 | Australia | Australia | Australia |
SO51341_4 | France | France | France |
SO51315_4 | Australia | Australia | Australia |
SO51267_4 | Australia | Australia | Australia |
SO51342_1 | United Kingdom | United Kingdom | United Kingdom |
SO51316_1 | France | France | France |
SO51267_5 | Australia | Australia | Australia |
SO51342_2 | United Kingdom | United Kingdom | United Kingdom |
SO51316_2 | France | France | France |
SO51267_6 | Australia | Australia | Australia |
SO51343_1 | France | France | France |
SO51316_3 | France | France | France |
SO51268_1 | Australia | Australia | Australia |
SO51343_2 | France | France | France |
SO51317_1 | France | France | France |
SO51268_2 | Australia | Australia | Australia |
SO51343_3 | France | France | France |
SO51317_2 | France | France | France |
SO51269_1 | Australia | Australia | Australia |
SO51344_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51317_3 | France | France | France |
SO51269_2 | Australia | Australia | Australia |
Generated 2025-07-08 08:53:21.906 UTC