[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4507 > < TAKE 48 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
48 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49634_1 | Australia | Australia | Australia |
SO49635_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49636_1 | Australia | Australia | Australia |
SO49637_1 | United Kingdom | United Kingdom | United Kingdom |
SO49638_1 | Germany | Germany | Germany |
SO49639_1 | France | France | France |
SO49640_1 | Germany | Germany | Germany |
SO49641_1 | Australia | Australia | Australia |
SO49642_1 | Australia | Australia | Australia |
SO49643_1 | Australia | Australia | Australia |
SO49644_1 | Australia | Australia | Australia |
SO49645_1 | France | France | France |
SO49646_1 | France | France | France |
SO49647_1 | Germany | Germany | Germany |
SO49648_1 | United Kingdom | United Kingdom | United Kingdom |
SO49649_1 | United Kingdom | United Kingdom | United Kingdom |
SO49650_1 | United Kingdom | United Kingdom | United Kingdom |
SO49651_1 | Australia | Australia | Australia |
SO49652_1 | Australia | Australia | Australia |
SO49653_1 | Australia | Australia | Australia |
SO49654_1 | Australia | Australia | Australia |
SO49655_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49656_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49657_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49658_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49659_1 | Canada | Canada | Canada |
SO49660_1 | Australia | Australia | Australia |
SO49661_1 | Australia | Australia | Australia |
SO49662_1 | Australia | Australia | Australia |
SO49663_1 | Australia | Australia | Australia |
SO50122_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50123_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50124_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50125_1 | Australia | Australia | Australia |
SO50126_1 | Australia | Australia | Australia |
SO50127_1 | Australia | Australia | Australia |
SO50128_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50129_1 | United Kingdom | United Kingdom | United Kingdom |
SO49938_1 | Germany | Germany | Germany |
SO50130_1 | Germany | Germany | Germany |
SO50066_1 | Australia | Australia | Australia |
SO49736_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49939_1 | France | France | France |
SO50131_1 | France | France | France |
SO50067_1 | Australia | Australia | Australia |
SO49737_1 | Australia | Australia | Australia |
SO49940_1 | United Kingdom | United Kingdom | United Kingdom |
SO50132_1 | United Kingdom | United Kingdom | United Kingdom |
Generated 2025-07-05 10:46:39.644 UTC