[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2924 > < TAKE 24 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
24 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47628_1 | United Kingdom | United Kingdom | United Kingdom |
SO47629_1 | Germany | Germany | Germany |
SO47630_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47631_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47632_1 | Canada | Canada | Canada |
SO47633_1 | Australia | Australia | Australia |
SO47634_1 | Germany | Germany | Germany |
SO47635_1 | United Kingdom | United Kingdom | United Kingdom |
SO47636_1 | Australia | Australia | Australia |
SO47637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47638_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47639_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47640_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47842_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47843_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47844_1 | Australia | Australia | Australia |
SO47845_1 | Germany | Germany | Germany |
SO47846_1 | France | France | France |
SO47847_1 | Germany | Germany | Germany |
SO47848_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47849_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47649_1 | United Kingdom | United Kingdom | United Kingdom |
SO47650_1 | United Kingdom | United Kingdom | United Kingdom |
SO47651_1 | Canada | Canada | Canada |
Generated 2025-07-14 03:24:29.639 UTC