[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7000 > < TAKE 250 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
250 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51934_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51935_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51935_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51936_1 | Canada | Canada | Canada |
SO51936_2 | Canada | Canada | Canada |
SO51936_3 | Canada | Canada | Canada |
SO51936_4 | Canada | Canada | Canada |
SO51937_1 | Canada | Canada | Canada |
SO51937_2 | Canada | Canada | Canada |
SO51937_3 | Canada | Canada | Canada |
SO51937_4 | Canada | Canada | Canada |
SO51938_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51939_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51940_1 | Canada | Canada | Canada |
SO51940_2 | Canada | Canada | Canada |
SO51940_3 | Canada | Canada | Canada |
SO51941_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51941_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51941_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51942_1 | Canada | Canada | Canada |
SO51942_2 | Canada | Canada | Canada |
SO51943_1 | Canada | Canada | Canada |
SO51943_2 | Canada | Canada | Canada |
SO51943_3 | Canada | Canada | Canada |
SO51944_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51944_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51945_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51945_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51946_1 | Canada | Canada | Canada |
SO51946_2 | Canada | Canada | Canada |
SO51947_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52024_2 | Australia | Australia | Australia |
SO52024_3 | Australia | Australia | Australia |
SO52025_1 | Australia | Australia | Australia |
SO52025_2 | Australia | Australia | Australia |
SO52025_3 | Australia | Australia | Australia |
SO52025_4 | Australia | Australia | Australia |
SO52026_1 | Australia | Australia | Australia |
SO52027_1 | Australia | Australia | Australia |
SO51950_2 | United Kingdom | United Kingdom | United Kingdom |
SO51950_3 | United Kingdom | United Kingdom | United Kingdom |
SO51951_1 | Germany | Germany | Germany |
SO51951_2 | Germany | Germany | Germany |
SO51951_3 | Germany | Germany | Germany |
SO51952_1 | United Kingdom | United Kingdom | United Kingdom |
SO51952_2 | United Kingdom | United Kingdom | United Kingdom |
SO51953_1 | Germany | Germany | Germany |
SO51953_2 | Germany | Germany | Germany |
SO51953_3 | Germany | Germany | Germany |
SO51954_1 | Germany | Germany | Germany |
SO51954_2 | Germany | Germany | Germany |
SO51955_1 | United Kingdom | United Kingdom | United Kingdom |
SO51955_2 | United Kingdom | United Kingdom | United Kingdom |
SO51955_3 | United Kingdom | United Kingdom | United Kingdom |
SO51956_1 | France | France | France |
SO51956_2 | France | France | France |
SO51957_1 | Canada | Canada | Canada |
SO51957_2 | Canada | Canada | Canada |
SO51957_3 | Canada | Canada | Canada |
SO51958_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51958_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51959_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51960_1 | United Kingdom | United Kingdom | United Kingdom |
SO51960_2 | United Kingdom | United Kingdom | United Kingdom |
SO51961_1 | Australia | Australia | Australia |
SO51962_1 | Canada | Canada | Canada |
SO51962_2 | Canada | Canada | Canada |
SO51963_1 | France | France | France |
SO51963_2 | France | France | France |
SO51963_3 | France | France | France |
SO51963_4 | France | France | France |
SO51964_1 | Australia | Australia | Australia |
SO51964_2 | Australia | Australia | Australia |
SO51964_3 | Australia | Australia | Australia |
SO51964_4 | Australia | Australia | Australia |
SO51965_1 | Australia | Australia | Australia |
SO51965_2 | Australia | Australia | Australia |
SO51965_3 | Australia | Australia | Australia |
SO51966_1 | Germany | Germany | Germany |
SO51966_2 | Germany | Germany | Germany |
SO51966_3 | Germany | Germany | Germany |
SO51966_4 | Germany | Germany | Germany |
SO51966_5 | Germany | Germany | Germany |
SO51966_6 | Germany | Germany | Germany |
SO51967_1 | Germany | Germany | Germany |
SO51967_2 | Germany | Germany | Germany |
SO51967_3 | Germany | Germany | Germany |
SO51967_4 | Germany | Germany | Germany |
SO51967_5 | Germany | Germany | Germany |
SO51968_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51969_1 | Australia | Australia | Australia |
SO51969_2 | Australia | Australia | Australia |
SO51970_1 | Australia | Australia | Australia |
SO52056_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52056_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52057_1 | Canada | Canada | Canada |
SO52057_2 | Canada | Canada | Canada |
SO52057_3 | Canada | Canada | Canada |
SO52058_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52027_2 | Australia | Australia | Australia |
SO52028_1 | Australia | Australia | Australia |
SO52028_2 | Australia | Australia | Australia |
SO52029_1 | Australia | Australia | Australia |
SO52030_1 | Australia | Australia | Australia |
SO52031_1 | Australia | Australia | Australia |
SO52032_1 | United Kingdom | United Kingdom | United Kingdom |
SO52032_2 | United Kingdom | United Kingdom | United Kingdom |
SO52033_1 | United Kingdom | United Kingdom | United Kingdom |
SO52033_2 | United Kingdom | United Kingdom | United Kingdom |
SO52033_3 | United Kingdom | United Kingdom | United Kingdom |
SO52033_4 | United Kingdom | United Kingdom | United Kingdom |
SO52034_1 | Canada | Canada | Canada |
SO52035_1 | Canada | Canada | Canada |
SO52035_2 | Canada | Canada | Canada |
SO52036_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52036_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52037_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52038_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52039_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52039_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52039_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52039_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52040_1 | Canada | Canada | Canada |
SO52040_2 | Canada | Canada | Canada |
SO52041_1 | Canada | Canada | Canada |
SO52041_2 | Canada | Canada | Canada |
SO52042_1 | Canada | Canada | Canada |
SO52042_2 | Canada | Canada | Canada |
SO52042_3 | Canada | Canada | Canada |
SO52043_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52043_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52044_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52044_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52044_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52045_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52045_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52046_1 | Canada | Canada | Canada |
SO52047_1 | Canada | Canada | Canada |
SO52047_2 | Canada | Canada | Canada |
SO52048_1 | Canada | Canada | Canada |
SO52048_2 | Canada | Canada | Canada |
SO52049_1 | France | France | France |
SO52049_2 | France | France | France |
SO52050_1 | France | France | France |
SO52050_2 | France | France | France |
SO52051_1 | France | France | France |
SO52052_1 | United Kingdom | United Kingdom | United Kingdom |
SO52053_1 | Canada | Canada | Canada |
SO52053_2 | Canada | Canada | Canada |
SO52054_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52054_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52054_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52055_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52055_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52055_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52111_1 | France | France | France |
SO52111_2 | France | France | France |
SO52112_1 | United Kingdom | United Kingdom | United Kingdom |
SO52112_2 | United Kingdom | United Kingdom | United Kingdom |
SO52112_3 | United Kingdom | United Kingdom | United Kingdom |
SO52112_4 | United Kingdom | United Kingdom | United Kingdom |
SO52112_5 | United Kingdom | United Kingdom | United Kingdom |
SO52113_1 | Canada | Canada | Canada |
SO52002_5 | Canada | Canada | Canada |
SO52003_1 | Canada | Canada | Canada |
SO52003_2 | Canada | Canada | Canada |
SO52003_3 | Canada | Canada | Canada |
SO52004_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52004_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52005_1 | Canada | Canada | Canada |
SO52005_2 | Canada | Canada | Canada |
SO52005_3 | Canada | Canada | Canada |
SO52006_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52006_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52007_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52007_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52008_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52009_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52010_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52011_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52012_1 | United Kingdom | United Kingdom | United Kingdom |
SO52012_2 | United Kingdom | United Kingdom | United Kingdom |
SO52013_1 | Germany | Germany | Germany |
SO52013_2 | Germany | Germany | Germany |
SO52014_1 | Australia | Australia | Australia |
SO52014_2 | Australia | Australia | Australia |
SO52015_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52015_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52016_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52016_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52017_1 | France | France | France |
SO52017_2 | France | France | France |
SO52017_3 | France | France | France |
SO52017_4 | France | France | France |
SO52018_1 | Australia | Australia | Australia |
SO52019_1 | Australia | Australia | Australia |
SO52019_2 | Australia | Australia | Australia |
SO52019_3 | Australia | Australia | Australia |
SO52020_1 | United Kingdom | United Kingdom | United Kingdom |
SO52020_2 | United Kingdom | United Kingdom | United Kingdom |
SO52021_1 | Germany | Germany | Germany |
SO52021_2 | Germany | Germany | Germany |
SO52021_3 | Germany | Germany | Germany |
SO52022_1 | United Kingdom | United Kingdom | United Kingdom |
SO52022_2 | United Kingdom | United Kingdom | United Kingdom |
SO52023_1 | Canada | Canada | Canada |
SO52024_1 | Australia | Australia | Australia |
SO52082_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52083_1 | Canada | Canada | Canada |
SO52083_2 | Canada | Canada | Canada |
SO52084_1 | Canada | Canada | Canada |
SO52084_2 | Canada | Canada | Canada |
SO52085_1 | Canada | Canada | Canada |
SO52085_2 | Canada | Canada | Canada |
SO52085_3 | Canada | Canada | Canada |
SO52058_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52058_6 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52059_1 | France | France | France |
SO52060_1 | Australia | Australia | Australia |
SO52060_2 | Australia | Australia | Australia |
SO52060_3 | Australia | Australia | Australia |
SO52061_1 | Australia | Australia | Australia |
SO52061_2 | Australia | Australia | Australia |
SO52062_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52062_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52063_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52063_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52063_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52064_1 | Germany | Germany | Germany |
SO52064_2 | Germany | Germany | Germany |
SO52065_1 | Australia | Australia | Australia |
Generated 2025-04-05 12:09:13.676 UTC