[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 196 > < TAKE 24 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
24 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO43921_1 | Australia | Australia | Australia |
SO44234_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43918_1 | Canada | Canada | Canada |
SO43926_1 | Australia | Australia | Australia |
SO43922_1 | Germany | Germany | Germany |
SO44235_1 | Canada | Canada | Canada |
SO43919_1 | France | France | France |
SO43927_1 | Australia | Australia | Australia |
SO43923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44236_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43920_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43928_1 | Australia | Australia | Australia |
SO43924_1 | France | France | France |
SO44237_1 | Australia | Australia | Australia |
SO43929_1 | Australia | Australia | Australia |
SO43937_1 | Australia | Australia | Australia |
SO43933_1 | Australia | Australia | Australia |
SO44238_1 | Australia | Australia | Australia |
SO43930_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43938_1 | Australia | Australia | Australia |
SO43934_1 | Australia | Australia | Australia |
SO44239_1 | France | France | France |
SO43931_1 | Germany | Germany | Germany |
SO43939_1 | Australia | Australia | Australia |
Generated 2025-07-10 02:51:13.690 UTC