[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5920 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51321_2 | Australia | Australia | Australia |
SO51322_1 | France | France | France |
SO51322_2 | France | France | France |
SO51323_1 | Germany | Germany | Germany |
SO51323_2 | Germany | Germany | Germany |
SO51324_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51326_1 | France | France | France |
SO51326_2 | France | France | France |
SO51327_1 | Australia | Australia | Australia |
SO51327_2 | Australia | Australia | Australia |
SO51327_3 | Australia | Australia | Australia |
SO51327_4 | Australia | Australia | Australia |
SO51328_1 | Australia | Australia | Australia |
SO51329_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51330_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51330_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51421_1 | Australia | Australia | Australia |
SO51422_1 | Australia | Australia | Australia |
SO51422_2 | Australia | Australia | Australia |
Generated 2025-07-09 03:38:41.007 UTC