[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 172 > < TAKE 24 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
24 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO43936_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43953_1 | United Kingdom | United Kingdom | United Kingdom |
SO43954_1 | United Kingdom | United Kingdom | United Kingdom |
SO43955_1 | United Kingdom | United Kingdom | United Kingdom |
SO43956_1 | Australia | Australia | Australia |
SO43957_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43958_1 | Australia | Australia | Australia |
SO43959_1 | Australia | Australia | Australia |
SO43960_1 | Australia | Australia | Australia |
SO43977_1 | Australia | Australia | Australia |
SO43978_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43979_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43980_1 | Australia | Australia | Australia |
SO43989_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43990_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43991_1 | Australia | Australia | Australia |
SO43992_1 | Australia | Australia | Australia |
SO43993_1 | Australia | Australia | Australia |
SO43994_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43995_1 | Canada | Canada | Canada |
SO43996_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43945_1 | Australia | Australia | Australia |
SO43946_1 | Australia | Australia | Australia |
SO43947_1 | Australia | Australia | Australia |
Generated 2025-07-10 19:22:55.714 UTC