[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5949 > < TAKE 12 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
12 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51362_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51362_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51363_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51363_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51363_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51364_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51365_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51365_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51365_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51365_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51366_1 | Australia | Australia | Australia |
SO51367_1 | Australia | Australia | Australia |
Generated 2025-07-14 05:46:34.014 UTC