[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2961 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47746_1 | Australia | Australia | Australia |
SO47747_1 | Germany | Germany | Germany |
SO47748_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47749_1 | Australia | Australia | Australia |
SO47750_1 | Australia | Australia | Australia |
SO47751_1 | Australia | Australia | Australia |
SO47752_1 | Australia | Australia | Australia |
SO47753_1 | Australia | Australia | Australia |
SO47754_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47755_1 | France | France | France |
SO47756_1 | United Kingdom | United Kingdom | United Kingdom |
SO47757_1 | United Kingdom | United Kingdom | United Kingdom |
SO47758_1 | United Kingdom | United Kingdom | United Kingdom |
SO47759_1 | France | France | France |
SO47760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47761_1 | Germany | Germany | Germany |
SO47762_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47763_1 | Australia | Australia | Australia |
SO47764_1 | France | France | France |
SO47765_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47766_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47767_1 | Australia | Australia | Australia |
SO47768_1 | Australia | Australia | Australia |
SO47769_1 | Australia | Australia | Australia |
SO47770_1 | Australia | Australia | Australia |
SO47771_1 | Australia | Australia | Australia |
SO47772_1 | Australia | Australia | Australia |
SO47773_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47774_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47775_1 | Australia | Australia | Australia |
SO47776_1 | Australia | Australia | Australia |
Generated 2025-07-09 15:02:53.017 UTC