[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 3893 > < TAKE 28 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
28 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49038_1 | Canada | Canada | Canada |
SO49171_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49172_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49173_1 | Australia | Australia | Australia |
SO49302_1 | France | France | France |
SO49303_1 | Germany | Germany | Germany |
SO49304_1 | United Kingdom | United Kingdom | United Kingdom |
SO49305_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49306_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49307_1 | Australia | Australia | Australia |
SO49308_1 | Australia | Australia | Australia |
SO49309_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48505_1 | France | France | France |
SO48506_1 | France | France | France |
SO48507_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO48508_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48509_1 | France | France | France |
SO48510_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48511_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48512_1 | Canada | Canada | Canada |
SO48513_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48514_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO48515_1 | Australia | Australia | Australia |
SO48516_1 | Australia | Australia | Australia |
SO48517_1 | Germany | Germany | Germany |
SO48518_1 | United Kingdom | United Kingdom | United Kingdom |
SO48519_1 | Germany | Germany | Germany |
SO48520_1 | Germany | Germany | Germany |
Generated 2025-07-09 01:11:26.762 UTC