[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 8219 > < TAKE 56 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
56 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52513_1 | Canada | Canada | Canada |
SO52513_2 | Canada | Canada | Canada |
SO52513_3 | Canada | Canada | Canada |
SO52513_4 | Canada | Canada | Canada |
SO52514_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52515_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52515_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52515_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52516_1 | Australia | Australia | Australia |
SO52516_2 | Australia | Australia | Australia |
SO52516_3 | Australia | Australia | Australia |
SO52517_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52517_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52517_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52518_1 | Canada | Canada | Canada |
SO52518_2 | Canada | Canada | Canada |
SO52518_3 | Canada | Canada | Canada |
SO52518_4 | Canada | Canada | Canada |
SO52519_1 | Canada | Canada | Canada |
SO52519_2 | Canada | Canada | Canada |
SO52519_3 | Canada | Canada | Canada |
SO52519_4 | Canada | Canada | Canada |
SO52520_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52520_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52520_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52521_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52521_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52522_1 | Australia | Australia | Australia |
SO52246_2 | France | France | France |
SO52522_2 | Australia | Australia | Australia |
SO52246_3 | France | France | France |
SO52522_3 | Australia | Australia | Australia |
SO52247_1 | France | France | France |
SO52552_1 | United Kingdom | United Kingdom | United Kingdom |
SO52248_1 | France | France | France |
SO52552_2 | United Kingdom | United Kingdom | United Kingdom |
SO52248_2 | France | France | France |
SO52553_1 | United Kingdom | United Kingdom | United Kingdom |
SO52248_3 | France | France | France |
SO52554_1 | United Kingdom | United Kingdom | United Kingdom |
SO52248_4 | France | France | France |
SO52554_2 | United Kingdom | United Kingdom | United Kingdom |
SO52248_5 | France | France | France |
SO52555_1 | United Kingdom | United Kingdom | United Kingdom |
SO52249_1 | Canada | Canada | Canada |
SO52555_2 | United Kingdom | United Kingdom | United Kingdom |
SO52249_2 | Canada | Canada | Canada |
SO52556_1 | Germany | Germany | Germany |
SO52250_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52250_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52251_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52251_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52252_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_2 | United Kingdom | United Kingdom | United Kingdom |
SO52253_3 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-09 04:21:41.454 UTC