[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4692 > < TAKE 56 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
56 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO50165_1 | United Kingdom | United Kingdom | United Kingdom |
SO50166_1 | United Kingdom | United Kingdom | United Kingdom |
SO50167_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50168_1 | Australia | Australia | Australia |
SO50169_1 | Australia | Australia | Australia |
SO50170_1 | Australia | Australia | Australia |
SO50171_1 | France | France | France |
SO50172_1 | France | France | France |
SO50173_1 | Australia | Australia | Australia |
SO50174_1 | Australia | Australia | Australia |
SO50175_1 | Australia | Australia | Australia |
SO50176_1 | France | France | France |
SO50177_1 | Australia | Australia | Australia |
SO50178_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50179_1 | Germany | Germany | Germany |
SO50180_1 | Germany | Germany | Germany |
SO50181_1 | Germany | Germany | Germany |
SO50182_1 | United Kingdom | United Kingdom | United Kingdom |
SO50183_1 | Germany | Germany | Germany |
SO50184_1 | France | France | France |
SO50185_1 | Germany | Germany | Germany |
SO50186_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50187_1 | Australia | Australia | Australia |
SO50188_1 | Australia | Australia | Australia |
SO50323_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50324_1 | United Kingdom | United Kingdom | United Kingdom |
SO50325_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50326_1 | Canada | Canada | Canada |
SO50327_1 | United Kingdom | United Kingdom | United Kingdom |
SO50328_1 | France | France | France |
SO50329_1 | France | France | France |
SO50330_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50331_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50332_1 | Australia | Australia | Australia |
SO50333_1 | Australia | Australia | Australia |
SO50334_1 | Australia | Australia | Australia |
SO50335_1 | Australia | Australia | Australia |
SO50336_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50337_1 | Canada | Canada | Canada |
SO50338_1 | Germany | Germany | Germany |
SO50339_1 | United Kingdom | United Kingdom | United Kingdom |
SO50340_1 | France | France | France |
SO50341_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50342_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50343_1 | Canada | Canada | Canada |
SO50082_1 | Germany | Germany | Germany |
SO50083_1 | France | France | France |
SO50084_1 | Germany | Germany | Germany |
SO50085_1 | Australia | Australia | Australia |
SO50086_1 | Australia | Australia | Australia |
SO50087_1 | Canada | Canada | Canada |
SO50088_1 | France | France | France |
SO50089_1 | France | France | France |
SO50090_1 | France | France | France |
SO50091_1 | France | France | France |
SO50092_1 | France | France | France |
Generated 2025-07-08 10:06:32.045 UTC