[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 1155 > < TAKE 16 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
16 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO45220_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45221_1 | Canada | Canada | Canada |
SO45222_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45223_1 | Australia | Australia | Australia |
SO45224_1 | Australia | Australia | Australia |
SO45225_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45226_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45227_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45228_1 | Australia | Australia | Australia |
SO45229_1 | United Kingdom | United Kingdom | United Kingdom |
SO45230_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45231_1 | Australia | Australia | Australia |
SO45232_1 | Australia | Australia | Australia |
SO45233_1 | Australia | Australia | Australia |
SO45234_1 | France | France | France |
SO45235_1 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-07-07 10:20:12.905 UTC