[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 401 > < TAKE 250 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
250 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44381_1 | United Kingdom | United Kingdom | United Kingdom |
SO43798_1 | Australia | Australia | Australia |
SO44009_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44373_1 | Germany | Germany | Germany |
SO44382_1 | United Kingdom | United Kingdom | United Kingdom |
SO43799_1 | Australia | Australia | Australia |
SO44010_1 | United Kingdom | United Kingdom | United Kingdom |
SO44374_1 | United Kingdom | United Kingdom | United Kingdom |
SO44383_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43800_1 | Canada | Canada | Canada |
SO44011_1 | Germany | Germany | Germany |
SO44375_1 | United Kingdom | United Kingdom | United Kingdom |
SO44384_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43801_1 | United Kingdom | United Kingdom | United Kingdom |
SO44012_1 | Australia | Australia | Australia |
SO44376_1 | Germany | Germany | Germany |
SO44393_1 | Germany | Germany | Germany |
SO43802_1 | France | France | France |
SO44013_1 | Australia | Australia | Australia |
SO44385_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44394_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43803_1 | Canada | Canada | Canada |
SO44014_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44386_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44395_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43804_1 | United Kingdom | United Kingdom | United Kingdom |
SO44015_1 | United Kingdom | United Kingdom | United Kingdom |
SO44387_1 | Australia | Australia | Australia |
SO44396_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43805_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44016_1 | United Kingdom | United Kingdom | United Kingdom |
SO44388_1 | Australia | Australia | Australia |
SO44397_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43806_1 | Australia | Australia | Australia |
SO44017_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44389_1 | Australia | Australia | Australia |
SO44398_1 | Australia | Australia | Australia |
SO43807_1 | France | France | France |
SO44018_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44390_1 | Australia | Australia | Australia |
SO44399_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43808_1 | Germany | Germany | Germany |
SO44019_1 | Australia | Australia | Australia |
SO44391_1 | Australia | Australia | Australia |
SO44400_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43809_1 | Australia | Australia | Australia |
SO44020_1 | Australia | Australia | Australia |
SO44392_1 | Australia | Australia | Australia |
SO44409_1 | Australia | Australia | Australia |
SO43810_1 | Australia | Australia | Australia |
SO44021_1 | Australia | Australia | Australia |
SO44401_1 | Australia | Australia | Australia |
SO44410_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43811_1 | Australia | Australia | Australia |
SO44022_1 | Canada | Canada | Canada |
SO44402_1 | Germany | Germany | Germany |
SO44411_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43812_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44023_1 | Canada | Canada | Canada |
SO44403_1 | Canada | Canada | Canada |
SO44412_1 | Australia | Australia | Australia |
SO43813_1 | France | France | France |
SO44024_1 | Australia | Australia | Australia |
SO44404_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44413_1 | Germany | Germany | Germany |
SO43814_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44025_1 | Australia | Australia | Australia |
SO44405_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44414_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43815_1 | Australia | Australia | Australia |
SO44026_1 | Australia | Australia | Australia |
SO44406_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44415_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43816_1 | Australia | Australia | Australia |
SO44027_1 | Canada | Canada | Canada |
SO44407_1 | Australia | Australia | Australia |
SO44416_1 | Australia | Australia | Australia |
SO43817_1 | Australia | Australia | Australia |
SO44028_1 | Australia | Australia | Australia |
SO44408_1 | Australia | Australia | Australia |
SO44433_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43818_1 | Australia | Australia | Australia |
SO44029_1 | Australia | Australia | Australia |
SO44417_1 | Australia | Australia | Australia |
SO44434_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43819_1 | Australia | Australia | Australia |
SO44030_1 | France | France | France |
SO44418_1 | Australia | Australia | Australia |
SO44435_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43820_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44031_1 | United Kingdom | United Kingdom | United Kingdom |
SO44419_1 | Australia | Australia | Australia |
SO44436_1 | Canada | Canada | Canada |
SO43821_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44032_1 | United Kingdom | United Kingdom | United Kingdom |
SO44420_1 | Australia | Australia | Australia |
SO44437_1 | Australia | Australia | Australia |
SO43822_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44033_1 | Australia | Australia | Australia |
SO44421_1 | Germany | Germany | Germany |
SO44438_1 | Australia | Australia | Australia |
SO43823_1 | United Kingdom | United Kingdom | United Kingdom |
SO44034_1 | Australia | Australia | Australia |
SO44422_1 | Germany | Germany | Germany |
SO44439_1 | United Kingdom | United Kingdom | United Kingdom |
SO43824_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44035_1 | Australia | Australia | Australia |
SO44423_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44440_1 | France | France | France |
SO43825_1 | Australia | Australia | Australia |
SO44036_1 | Australia | Australia | Australia |
SO44424_1 | Australia | Australia | Australia |
SO44441_1 | Canada | Canada | Canada |
SO43826_1 | Australia | Australia | Australia |
SO44037_1 | Australia | Australia | Australia |
SO44442_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43827_1 | Australia | Australia | Australia |
SO44038_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44443_1 | Australia | Australia | Australia |
SO43828_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44039_1 | France | France | France |
SO44444_1 | Germany | Germany | Germany |
SO43829_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44040_1 | Australia | Australia | Australia |
SO44445_1 | Australia | Australia | Australia |
SO43830_1 | Australia | Australia | Australia |
SO44041_1 | Australia | Australia | Australia |
SO44446_1 | Australia | Australia | Australia |
SO43831_1 | Australia | Australia | Australia |
SO44042_1 | United Kingdom | United Kingdom | United Kingdom |
SO44447_1 | France | France | France |
SO43832_1 | United Kingdom | United Kingdom | United Kingdom |
SO44043_1 | United Kingdom | United Kingdom | United Kingdom |
SO44448_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43833_1 | Canada | Canada | Canada |
SO44044_1 | United Kingdom | United Kingdom | United Kingdom |
SO44449_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44619_1 | Germany | Germany | Germany |
SO44045_1 | France | France | France |
SO44450_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44620_1 | Australia | Australia | Australia |
SO44046_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44451_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44621_1 | Australia | Australia | Australia |
SO44047_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44452_1 | United Kingdom | United Kingdom | United Kingdom |
SO44622_1 | Germany | Germany | Germany |
SO44048_1 | Australia | Australia | Australia |
SO44453_1 | Australia | Australia | Australia |
SO44623_1 | France | France | France |
SO44049_1 | Germany | Germany | Germany |
SO44454_1 | Australia | Australia | Australia |
SO44624_1 | Germany | Germany | Germany |
SO44050_1 | Australia | Australia | Australia |
SO44455_1 | Australia | Australia | Australia |
SO44625_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44051_1 | United Kingdom | United Kingdom | United Kingdom |
SO44456_1 | Australia | Australia | Australia |
SO44626_1 | Australia | Australia | Australia |
SO44052_1 | Australia | Australia | Australia |
SO44457_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44627_1 | Australia | Australia | Australia |
SO44053_1 | Germany | Germany | Germany |
SO44458_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44628_1 | Australia | Australia | Australia |
SO44054_1 | Germany | Germany | Germany |
SO44459_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44629_1 | Australia | Australia | Australia |
SO44055_1 | Germany | Germany | Germany |
SO44460_1 | United Kingdom | United Kingdom | United Kingdom |
SO44630_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44056_1 | Germany | Germany | Germany |
SO44461_1 | Australia | Australia | Australia |
SO44631_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44057_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44462_1 | United Kingdom | United Kingdom | United Kingdom |
SO44632_1 | Australia | Australia | Australia |
SO44058_1 | Australia | Australia | Australia |
SO44463_1 | Germany | Germany | Germany |
SO44633_1 | Australia | Australia | Australia |
SO44059_1 | Australia | Australia | Australia |
SO44464_1 | Canada | Canada | Canada |
SO44634_1 | Australia | Australia | Australia |
SO44060_1 | Australia | Australia | Australia |
SO44571_1 | Germany | Germany | Germany |
SO44651_1 | United Kingdom | United Kingdom | United Kingdom |
SO44061_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44572_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44652_1 | France | France | France |
SO44062_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44573_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44653_1 | United Kingdom | United Kingdom | United Kingdom |
SO44063_1 | United Kingdom | United Kingdom | United Kingdom |
SO44574_1 | Australia | Australia | Australia |
SO44654_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44064_1 | Canada | Canada | Canada |
SO44575_1 | Australia | Australia | Australia |
SO44655_1 | Australia | Australia | Australia |
SO44065_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44576_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44656_1 | Australia | Australia | Australia |
SO44066_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44577_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44657_1 | Australia | Australia | Australia |
SO44067_1 | Australia | Australia | Australia |
SO44578_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44658_1 | Australia | Australia | Australia |
SO44068_1 | Germany | Germany | Germany |
SO44579_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44659_1 | Australia | Australia | Australia |
SO44069_1 | France | France | France |
SO44580_1 | Germany | Germany | Germany |
SO44660_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44070_1 | Canada | Canada | Canada |
SO44581_1 | Australia | Australia | Australia |
SO44661_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44071_1 | Australia | Australia | Australia |
SO44582_1 | Australia | Australia | Australia |
SO44662_1 | Australia | Australia | Australia |
SO44072_1 | Australia | Australia | Australia |
SO44583_1 | Australia | Australia | Australia |
SO44663_1 | Australia | Australia | Australia |
SO44073_1 | Australia | Australia | Australia |
SO44584_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44664_1 | Australia | Australia | Australia |
SO44134_1 | United Kingdom | United Kingdom | United Kingdom |
SO44585_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44665_1 | Australia | Australia | Australia |
SO44135_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44586_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44666_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44136_1 | Canada | Canada | Canada |
SO44603_1 | United Kingdom | United Kingdom | United Kingdom |
SO44683_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45018_1 | Australia | Australia | Australia |
SO44604_1 | Germany | Germany | Germany |
SO44684_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45019_1 | Australia | Australia | Australia |
SO44605_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44685_1 | Australia | Australia | Australia |
SO45020_1 | Australia | Australia | Australia |
SO44606_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44686_1 | United Kingdom | United Kingdom | United Kingdom |
SO45021_1 | Australia | Australia | Australia |
SO44607_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44687_1 | United Kingdom | United Kingdom | United Kingdom |
SO45022_1 | Australia | Australia | Australia |
SO44608_1 | Australia | Australia | Australia |
SO44688_1 | Australia | Australia | Australia |
SO45023_1 | Germany | Germany | Germany |
Generated 2025-07-10 04:35:09.384 UTC