[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5920 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51367_1 | Australia | Australia | Australia |
SO51367_2 | Australia | Australia | Australia |
SO51368_1 | Australia | Australia | Australia |
SO51368_2 | Australia | Australia | Australia |
SO51369_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51369_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51369_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51370_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51370_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51370_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51370_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51370_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51370_6 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51371_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51371_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51371_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51371_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51372_1 | France | France | France |
SO51372_2 | France | France | France |
SO51373_1 | Germany | Germany | Germany |
SO51373_2 | Germany | Germany | Germany |
SO51374_1 | Australia | Australia | Australia |
SO51374_2 | Australia | Australia | Australia |
SO51375_1 | Australia | Australia | Australia |
SO51375_2 | Australia | Australia | Australia |
SO51421_1 | Australia | Australia | Australia |
SO51422_1 | Australia | Australia | Australia |
SO51422_2 | Australia | Australia | Australia |
Generated 2025-07-09 01:19:53.075 UTC