[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 1160 > < TAKE 15 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
15 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO45424_1 | Canada | Canada | Canada |
SO44954_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45106_1 | Canada | Canada | Canada |
SO45457_1 | Canada | Canada | Canada |
SO44955_1 | Australia | Australia | Australia |
SO45107_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45458_1 | Australia | Australia | Australia |
SO44956_1 | Australia | Australia | Australia |
SO45108_1 | Canada | Canada | Canada |
SO45459_1 | Australia | Australia | Australia |
SO44957_1 | Canada | Canada | Canada |
SO45109_1 | United Kingdom | United Kingdom | United Kingdom |
SO45460_1 | Australia | Australia | Australia |
SO44958_1 | United Kingdom | United Kingdom | United Kingdom |
SO45110_1 | Australia | Australia | Australia |
Generated 2025-07-09 22:52:16.186 UTC