[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 375 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44188_1 | United Kingdom | United Kingdom | United Kingdom |
SO44204_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44189_1 | United Kingdom | United Kingdom | United Kingdom |
SO44205_1 | Australia | Australia | Australia |
SO44190_1 | Australia | Australia | Australia |
SO44206_1 | United Kingdom | United Kingdom | United Kingdom |
SO44191_1 | Australia | Australia | Australia |
SO44207_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44192_1 | Germany | Germany | Germany |
SO44208_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44345_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44265_1 | Australia | Australia | Australia |
SO44193_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44209_1 | Australia | Australia | Australia |
SO44346_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44266_1 | Australia | Australia | Australia |
SO44194_1 | Australia | Australia | Australia |
SO44210_1 | United Kingdom | United Kingdom | United Kingdom |
SO44347_1 | Australia | Australia | Australia |
SO44267_1 | Germany | Germany | Germany |
SO44195_1 | Australia | Australia | Australia |
SO44211_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44348_1 | United Kingdom | United Kingdom | United Kingdom |
SO44268_1 | United Kingdom | United Kingdom | United Kingdom |
SO44196_1 | Australia | Australia | Australia |
SO44212_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44349_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44269_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44197_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44213_1 | Australia | Australia | Australia |
SO44350_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-04-06 19:11:56.481 UTC