[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 750 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44817_1 | United Kingdom | United Kingdom | United Kingdom |
SO44690_1 | Australia | Australia | Australia |
SO44706_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44818_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44691_1 | France | France | France |
SO44707_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44819_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44692_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44708_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44820_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44693_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44709_1 | Australia | Australia | Australia |
SO44821_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44694_1 | Canada | Canada | Canada |
SO44710_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44822_1 | Australia | Australia | Australia |
SO44695_1 | Canada | Canada | Canada |
SO44711_1 | Australia | Australia | Australia |
SO44823_1 | Australia | Australia | Australia |
SO44696_1 | Australia | Australia | Australia |
SO44712_1 | Australia | Australia | Australia |
SO44824_1 | Australia | Australia | Australia |
SO44697_1 | Australia | Australia | Australia |
SO44713_1 | Canada | Canada | Canada |
SO44825_1 | Australia | Australia | Australia |
SO44698_1 | Australia | Australia | Australia |
SO44714_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44874_1 | France | France | France |
SO44826_1 | France | France | France |
SO44731_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44875_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2024-11-10 06:12:56.532 UTC