[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2846 > < TAKE 96 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
96 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47345_1 | Australia | Australia | Australia |
SO47520_1 | United Kingdom | United Kingdom | United Kingdom |
SO47281_1 | France | France | France |
SO47786_1 | France | France | France |
SO47346_1 | Australia | Australia | Australia |
SO47521_1 | United Kingdom | United Kingdom | United Kingdom |
SO47282_1 | United Kingdom | United Kingdom | United Kingdom |
SO47787_1 | United Kingdom | United Kingdom | United Kingdom |
SO47347_1 | Australia | Australia | Australia |
SO47522_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47283_1 | Germany | Germany | Germany |
SO47788_1 | United Kingdom | United Kingdom | United Kingdom |
SO47348_1 | Australia | Australia | Australia |
SO47523_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47284_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47789_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47460_1 | France | France | France |
SO47524_1 | Australia | Australia | Australia |
SO47285_1 | Canada | Canada | Canada |
SO47790_1 | Australia | Australia | Australia |
SO47461_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47525_1 | Australia | Australia | Australia |
SO47286_1 | Germany | Germany | Germany |
SO47791_1 | Australia | Australia | Australia |
SO47462_1 | Germany | Germany | Germany |
SO47526_1 | United Kingdom | United Kingdom | United Kingdom |
SO47287_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47792_1 | Germany | Germany | Germany |
SO47463_1 | France | France | France |
SO47527_1 | France | France | France |
SO47288_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47793_1 | France | France | France |
SO47464_1 | United Kingdom | United Kingdom | United Kingdom |
SO47528_1 | Germany | Germany | Germany |
SO47289_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47794_1 | Canada | Canada | Canada |
SO47465_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47529_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47290_1 | Australia | Australia | Australia |
SO47795_1 | Australia | Australia | Australia |
SO47466_1 | Australia | Australia | Australia |
SO47530_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47291_1 | United Kingdom | United Kingdom | United Kingdom |
SO47796_1 | Australia | Australia | Australia |
SO47467_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47531_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47292_1 | France | France | France |
SO47797_1 | Australia | Australia | Australia |
SO47468_1 | Australia | Australia | Australia |
SO47532_1 | Australia | Australia | Australia |
SO47293_1 | United Kingdom | United Kingdom | United Kingdom |
SO47798_1 | Australia | Australia | Australia |
SO47469_1 | United Kingdom | United Kingdom | United Kingdom |
SO47533_1 | Australia | Australia | Australia |
SO47294_1 | Germany | Germany | Germany |
SO47799_1 | United Kingdom | United Kingdom | United Kingdom |
SO47470_1 | France | France | France |
SO47534_1 | Australia | Australia | Australia |
SO47295_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47800_1 | France | France | France |
SO47471_1 | France | France | France |
SO47535_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47296_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47801_1 | Germany | Germany | Germany |
SO47472_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47536_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47297_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47866_1 | Australia | Australia | Australia |
SO47601_1 | France | France | France |
SO47633_1 | Australia | Australia | Australia |
SO47802_1 | United Kingdom | United Kingdom | United Kingdom |
SO47867_1 | Australia | Australia | Australia |
SO47602_1 | France | France | France |
SO47634_1 | Germany | Germany | Germany |
SO47803_1 | Australia | Australia | Australia |
SO47868_1 | Australia | Australia | Australia |
SO47603_1 | Australia | Australia | Australia |
SO47635_1 | United Kingdom | United Kingdom | United Kingdom |
SO47804_1 | Australia | Australia | Australia |
SO47869_1 | Australia | Australia | Australia |
SO47604_1 | Australia | Australia | Australia |
SO47636_1 | Australia | Australia | Australia |
SO47805_1 | Australia | Australia | Australia |
SO47870_1 | United Kingdom | United Kingdom | United Kingdom |
SO47605_1 | France | France | France |
SO47637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47806_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47871_1 | France | France | France |
SO47606_1 | Germany | Germany | Germany |
SO47638_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47807_1 | United Kingdom | United Kingdom | United Kingdom |
SO47872_1 | France | France | France |
SO47607_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47639_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47808_1 | Australia | Australia | Australia |
SO47873_1 | Canada | Canada | Canada |
Generated 2025-07-10 11:18:06.629 UTC