[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 46 > < TAKE 24 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
24 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO43720_1 | Germany | Germany | Germany |
SO43948_1 | Australia | Australia | Australia |
SO43721_1 | United Kingdom | United Kingdom | United Kingdom |
SO43949_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43722_1 | United Kingdom | United Kingdom | United Kingdom |
SO43950_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43723_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43951_1 | Australia | Australia | Australia |
SO43724_1 | Australia | Australia | Australia |
SO43952_1 | Australia | Australia | Australia |
SO43725_1 | Germany | Germany | Germany |
SO43953_1 | United Kingdom | United Kingdom | United Kingdom |
SO43726_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43954_1 | United Kingdom | United Kingdom | United Kingdom |
SO43727_1 | Australia | Australia | Australia |
SO43955_1 | United Kingdom | United Kingdom | United Kingdom |
SO43728_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43956_1 | Australia | Australia | Australia |
SO43729_1 | United Kingdom | United Kingdom | United Kingdom |
SO43957_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43730_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43958_1 | Australia | Australia | Australia |
SO43731_1 | Australia | Australia | Australia |
SO43959_1 | Australia | Australia | Australia |
Generated 2025-07-07 23:18:24.027 UTC