[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 |
---|---|---|---|
SO51264_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51264_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51264_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51264_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51265_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51265_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51265_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51265_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51266_1 | Australia | Australia | Australia |
SO51267_1 | Australia | Australia | Australia |
SO51267_2 | Australia | Australia | Australia |
SO51267_3 | Australia | Australia | Australia |
SO51267_4 | Australia | Australia | Australia |
SO51267_5 | Australia | Australia | Australia |
SO51267_6 | Australia | Australia | Australia |
SO51268_1 | Australia | Australia | Australia |
SO51268_2 | Australia | Australia | Australia |
SO51269_1 | Australia | Australia | Australia |
SO51269_2 | Australia | Australia | Australia |
SO51269_3 | Australia | Australia | Australia |
SO51269_4 | Australia | Australia | Australia |
SO51270_1 | United Kingdom | United Kingdom | United Kingdom |
SO51270_2 | United Kingdom | United Kingdom | United Kingdom |
SO51270_3 | United Kingdom | United Kingdom | United Kingdom |
SO51271_1 | Germany | Germany | Germany |
SO51271_2 | Germany | Germany | Germany |
SO51271_3 | Germany | Germany | Germany |
SO51271_4 | Germany | Germany | Germany |
SO51272_1 | United Kingdom | United Kingdom | United Kingdom |
SO51272_2 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-08 06:01:40.718 UTC