[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 166 > < TAKE 12 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
12 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO43934_1 | Australia | Australia | Australia |
SO43935_1 | United Kingdom | United Kingdom | United Kingdom |
SO43936_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43949_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43950_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43951_1 | Australia | Australia | Australia |
SO43952_1 | Australia | Australia | Australia |
SO43965_1 | Australia | Australia | Australia |
SO43966_1 | Australia | Australia | Australia |
SO43967_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43968_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43985_1 | Germany | Germany | Germany |
Generated 2025-07-08 12:44:58.225 UTC