[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 1112 > < TAKE 32 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
32 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO45231_1 | Australia | Australia | Australia |
SO45200_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44872_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45016_1 | United Kingdom | United Kingdom | United Kingdom |
SO45232_1 | Australia | Australia | Australia |
SO45201_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44873_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45017_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45233_1 | Australia | Australia | Australia |
SO45202_1 | Australia | Australia | Australia |
SO44874_1 | France | France | France |
SO45018_1 | Australia | Australia | Australia |
SO45234_1 | France | France | France |
SO45203_1 | Australia | Australia | Australia |
SO44875_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45019_1 | Australia | Australia | Australia |
SO45235_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45204_1 | Australia | Australia | Australia |
SO44876_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45020_1 | Australia | Australia | Australia |
SO45236_1 | Australia | Australia | Australia |
SO45205_1 | France | France | France |
SO44877_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45021_1 | Australia | Australia | Australia |
SO45237_1 | Australia | Australia | Australia |
SO45206_1 | France | France | France |
SO44878_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45022_1 | Australia | Australia | Australia |
SO45238_1 | Australia | Australia | Australia |
SO45207_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45023_1 | Germany | Germany | Germany |
Generated 2025-07-15 07:42:13.572 UTC