[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5523 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51288_3 | Germany | Germany | Germany |
SO51265_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51289_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51266_1 | Australia | Australia | Australia |
SO51289_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51267_1 | Australia | Australia | Australia |
SO51290_1 | Australia | Australia | Australia |
SO51267_2 | Australia | Australia | Australia |
SO51290_2 | Australia | Australia | Australia |
SO51267_3 | Australia | Australia | Australia |
SO51291_1 | Australia | Australia | Australia |
SO51267_4 | Australia | Australia | Australia |
SO51291_2 | Australia | Australia | Australia |
SO51267_5 | Australia | Australia | Australia |
SO51291_3 | Australia | Australia | Australia |
SO51267_6 | Australia | Australia | Australia |
SO51292_1 | Australia | Australia | Australia |
SO51268_1 | Australia | Australia | Australia |
SO51292_2 | Australia | Australia | Australia |
SO51268_2 | Australia | Australia | Australia |
SO51293_1 | Australia | Australia | Australia |
SO51269_1 | Australia | Australia | Australia |
SO51294_1 | Australia | Australia | Australia |
SO51269_2 | Australia | Australia | Australia |
SO51294_2 | Australia | Australia | Australia |
SO51269_3 | Australia | Australia | Australia |
SO51294_3 | Australia | Australia | Australia |
SO51269_4 | Australia | Australia | Australia |
Generated 2025-07-17 01:54:20.901 UTC