[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4897 > < TAKE 12 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
12 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO50568_1 | United Kingdom | United Kingdom | United Kingdom |
SO50178_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50569_1 | Germany | Germany | Germany |
SO50179_1 | Germany | Germany | Germany |
SO50570_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50180_1 | Germany | Germany | Germany |
SO50571_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50181_1 | Germany | Germany | Germany |
SO50572_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50182_1 | United Kingdom | United Kingdom | United Kingdom |
SO50573_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50183_1 | Germany | Germany | Germany |
Generated 2025-07-13 12:46:22.803 UTC