[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 420 > < TAKE 56 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
56 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44252_1 | United Kingdom | United Kingdom | United Kingdom |
SO44253_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44254_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44255_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44256_1 | Australia | Australia | Australia |
SO44329_1 | Australia | Australia | Australia |
SO44330_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44331_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44332_1 | Australia | Australia | Australia |
SO44333_1 | United Kingdom | United Kingdom | United Kingdom |
SO44334_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44335_1 | United Kingdom | United Kingdom | United Kingdom |
SO44336_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44353_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44354_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44355_1 | Australia | Australia | Australia |
SO44356_1 | Australia | Australia | Australia |
SO44357_1 | Australia | Australia | Australia |
SO44358_1 | Australia | Australia | Australia |
SO44359_1 | United Kingdom | United Kingdom | United Kingdom |
SO44360_1 | United Kingdom | United Kingdom | United Kingdom |
SO44393_1 | Germany | Germany | Germany |
SO44394_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44395_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44396_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44397_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44398_1 | Australia | Australia | Australia |
SO44399_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44400_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44233_1 | United Kingdom | United Kingdom | United Kingdom |
SO44234_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44235_1 | Canada | Canada | Canada |
SO44236_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44237_1 | Australia | Australia | Australia |
SO44238_1 | Australia | Australia | Australia |
SO44239_1 | France | France | France |
SO44240_1 | Germany | Germany | Germany |
SO44257_1 | France | France | France |
SO44258_1 | Germany | Germany | Germany |
SO44259_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44260_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44261_1 | Canada | Canada | Canada |
SO44262_1 | United Kingdom | United Kingdom | United Kingdom |
SO44263_1 | Australia | Australia | Australia |
SO44264_1 | Australia | Australia | Australia |
SO44265_1 | Australia | Australia | Australia |
SO44266_1 | Australia | Australia | Australia |
SO44267_1 | Germany | Germany | Germany |
SO44268_1 | United Kingdom | United Kingdom | United Kingdom |
SO44269_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44270_1 | United Kingdom | United Kingdom | United Kingdom |
SO44271_1 | United Kingdom | United Kingdom | United Kingdom |
SO44272_1 | France | France | France |
SO44337_1 | Australia | Australia | Australia |
SO44338_1 | Australia | Australia | Australia |
SO44339_1 | Australia | Australia | Australia |
Generated 2025-07-09 03:50:12.538 UTC