[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 1500 > < TAKE 62 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
62 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO45817_1 | Germany | Germany | Germany |
SO45818_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45819_1 | Australia | Australia | Australia |
SO45820_1 | Australia | Australia | Australia |
SO45821_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45822_1 | Australia | Australia | Australia |
SO45823_1 | Australia | Australia | Australia |
SO45824_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45825_1 | Canada | Canada | Canada |
SO45826_1 | Canada | Canada | Canada |
SO45827_1 | United Kingdom | United Kingdom | United Kingdom |
SO45828_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45829_1 | Australia | Australia | Australia |
SO45830_1 | Australia | Australia | Australia |
SO45831_1 | Australia | Australia | Australia |
SO45832_1 | Australia | Australia | Australia |
SO45833_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45834_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45835_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45836_1 | Germany | Germany | Germany |
SO45837_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45838_1 | Australia | Australia | Australia |
SO45839_1 | Australia | Australia | Australia |
SO45840_1 | Germany | Germany | Germany |
SO45841_1 | France | France | France |
SO45842_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45843_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45844_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45845_1 | Canada | Canada | Canada |
SO45942_1 | Australia | Australia | Australia |
SO45943_1 | Australia | Australia | Australia |
SO45944_1 | Australia | Australia | Australia |
SO45945_1 | Australia | Australia | Australia |
SO45946_1 | Australia | Australia | Australia |
SO45947_1 | Australia | Australia | Australia |
SO45948_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45949_1 | Australia | Australia | Australia |
SO45753_1 | Australia | Australia | Australia |
SO45754_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45755_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45756_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45757_1 | France | France | France |
SO45758_1 | United Kingdom | United Kingdom | United Kingdom |
SO45759_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45760_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45761_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45762_1 | France | France | France |
SO45763_1 | Australia | Australia | Australia |
SO45764_1 | Australia | Australia | Australia |
SO45765_1 | Germany | Germany | Germany |
SO45766_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45497_1 | Canada | Canada | Canada |
SO45767_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45498_1 | Canada | Canada | Canada |
SO45768_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45499_1 | Canada | Canada | Canada |
SO45769_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45500_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45770_1 | Australia | Australia | Australia |
SO45501_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45771_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45502_1 | Canada | Canada | Canada |
Generated 2024-09-20 00:02:34.563 UTC