[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8645 > < TAKE 56 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
56 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52610_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52610_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52610_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52611_1 | Canada | Canada | Canada |
SO52611_2 | Canada | Canada | Canada |
SO52611_3 | Canada | Canada | Canada |
SO52612_1 | United Kingdom | United Kingdom | United Kingdom |
SO52612_2 | United Kingdom | United Kingdom | United Kingdom |
SO52612_3 | United Kingdom | United Kingdom | United Kingdom |
SO52612_4 | United Kingdom | United Kingdom | United Kingdom |
SO52613_1 | United Kingdom | United Kingdom | United Kingdom |
SO52613_2 | United Kingdom | United Kingdom | United Kingdom |
SO52613_3 | United Kingdom | United Kingdom | United Kingdom |
SO52613_4 | United Kingdom | United Kingdom | United Kingdom |
SO52614_1 | France | France | France |
SO52614_2 | France | France | France |
SO52614_3 | France | France | France |
SO52615_1 | France | France | France |
SO52615_2 | France | France | France |
SO52616_1 | United Kingdom | United Kingdom | United Kingdom |
SO52616_2 | United Kingdom | United Kingdom | United Kingdom |
SO52616_3 | United Kingdom | United Kingdom | United Kingdom |
SO52616_4 | United Kingdom | United Kingdom | United Kingdom |
SO52617_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52617_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52617_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52618_1 | Australia | Australia | Australia |
SO52618_2 | Australia | Australia | Australia |
SO52618_3 | Australia | Australia | Australia |
SO52619_1 | Australia | Australia | Australia |
SO52619_2 | Australia | Australia | Australia |
SO52620_1 | Australia | Australia | Australia |
SO52620_2 | Australia | Australia | Australia |
SO52620_3 | Australia | Australia | Australia |
SO52621_1 | Australia | Australia | Australia |
SO52622_1 | Australia | Australia | Australia |
SO52623_1 | Australia | Australia | Australia |
SO52624_1 | Australia | Australia | Australia |
SO52625_1 | France | France | France |
SO52626_1 | Canada | Canada | Canada |
SO52626_2 | Canada | Canada | Canada |
SO52626_3 | Canada | Canada | Canada |
SO52627_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52627_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52627_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52628_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52629_1 | Canada | Canada | Canada |
SO52629_2 | Canada | Canada | Canada |
SO52630_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52630_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52714_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52715_1 | Canada | Canada | Canada |
SO52715_2 | Canada | Canada | Canada |
SO52715_3 | Canada | Canada | Canada |
Generated 2025-07-08 06:03:38.730 UTC