[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5850 > < TAKE 56 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
56 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51326_1 | France | France | France |
SO51326_2 | France | France | France |
SO51327_1 | Australia | Australia | Australia |
SO51327_2 | Australia | Australia | Australia |
SO51327_3 | Australia | Australia | Australia |
SO51327_4 | Australia | Australia | Australia |
SO51328_1 | Australia | Australia | Australia |
SO51329_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51330_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51330_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51332_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51333_1 | United Kingdom | United Kingdom | United Kingdom |
SO51333_2 | United Kingdom | United Kingdom | United Kingdom |
SO51333_3 | United Kingdom | United Kingdom | United Kingdom |
SO51334_1 | France | France | France |
SO51334_2 | France | France | France |
SO51335_1 | France | France | France |
SO51335_2 | France | France | France |
SO51336_1 | Australia | Australia | Australia |
SO51336_2 | Australia | Australia | Australia |
SO51336_3 | Australia | Australia | Australia |
SO51337_1 | Australia | Australia | Australia |
SO51338_1 | Australia | Australia | Australia |
SO51339_1 | Germany | Germany | Germany |
SO51339_2 | Germany | Germany | Germany |
SO51339_3 | Germany | Germany | Germany |
SO51359_4 | Australia | Australia | Australia |
SO51359_5 | Australia | Australia | Australia |
SO51360_1 | United Kingdom | United Kingdom | United Kingdom |
SO51360_2 | United Kingdom | United Kingdom | United Kingdom |
SO51360_3 | United Kingdom | United Kingdom | United Kingdom |
SO51360_4 | United Kingdom | United Kingdom | United Kingdom |
SO51361_1 | Germany | Germany | Germany |
SO51361_2 | Germany | Germany | Germany |
SO51342_2 | United Kingdom | United Kingdom | United Kingdom |
SO51343_1 | France | France | France |
SO51343_2 | France | France | France |
SO51343_3 | France | France | France |
SO51344_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51344_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51344_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51344_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51344_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51345_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51345_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51345_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51345_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51346_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51346_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51346_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51346_4 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-07-10 11:15:42.068 UTC