[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3428 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO48508_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48509_1 | France | France | France |
SO48510_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48511_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48512_1 | Canada | Canada | Canada |
SO48513_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48514_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48515_1 | Australia | Australia | Australia |
SO48516_1 | Australia | Australia | Australia |
SO48517_1 | Germany | Germany | Germany |
SO48518_1 | United Kingdom | United Kingdom | United Kingdom |
SO48519_1 | Germany | Germany | Germany |
SO48520_1 | Germany | Germany | Germany |
SO48617_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48618_1 | Canada | Canada | Canada |
SO48619_1 | Australia | Australia | Australia |
SO48620_1 | Canada | Canada | Canada |
SO48621_1 | Australia | Australia | Australia |
SO48622_1 | Australia | Australia | Australia |
SO48623_1 | Australia | Australia | Australia |
SO48624_1 | Australia | Australia | Australia |
SO48625_1 | Australia | Australia | Australia |
SO48626_1 | Australia | Australia | Australia |
SO48627_1 | France | France | France |
SO48628_1 | United Kingdom | United Kingdom | United Kingdom |
SO48629_1 | Australia | Australia | Australia |
SO48630_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48631_1 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-09 09:00:57.104 UTC