[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 514 > < TAKE 24 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
24 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44265_1 | Australia | Australia | Australia |
SO44434_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44266_1 | Australia | Australia | Australia |
SO44435_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44267_1 | Germany | Germany | Germany |
SO44436_1 | Canada | Canada | Canada |
SO44268_1 | United Kingdom | United Kingdom | United Kingdom |
SO44437_1 | Australia | Australia | Australia |
SO44269_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44438_1 | Australia | Australia | Australia |
SO44270_1 | United Kingdom | United Kingdom | United Kingdom |
SO44439_1 | United Kingdom | United Kingdom | United Kingdom |
SO44271_1 | United Kingdom | United Kingdom | United Kingdom |
SO44440_1 | France | France | France |
SO44272_1 | France | France | France |
SO44477_1 | Australia | Australia | Australia |
SO44273_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44478_1 | Australia | Australia | Australia |
SO44274_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44479_1 | Germany | Germany | Germany |
SO44275_1 | Australia | Australia | Australia |
SO44480_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44276_1 | Australia | Australia | Australia |
SO44571_1 | Germany | Germany | Germany |
Generated 2025-07-07 13:10:10.787 UTC