[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 4469 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO49926_1 | France | France | France |
SO49927_1 | France | France | France |
SO49928_1 | France | France | France |
SO49929_1 | France | France | France |
SO50058_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50059_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50060_1 | Australia | Australia | Australia |
SO50061_1 | Australia | Australia | Australia |
SO50062_1 | Australia | Australia | Australia |
SO50063_1 | Australia | Australia | Australia |
SO50064_1 | Australia | Australia | Australia |
SO50065_1 | Australia | Australia | Australia |
SO50002_1 | Australia | Australia | Australia |
SO50003_1 | Australia | Australia | Australia |
SO50004_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50005_1 | Germany | Germany | Germany |
SO50006_1 | Germany | Germany | Germany |
SO50007_1 | Australia | Australia | Australia |
SO50008_1 | Australia | Australia | Australia |
SO50009_1 | Australia | Australia | Australia |
SO50010_1 | Australia | Australia | Australia |
SO50011_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50012_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50013_1 | United Kingdom | United Kingdom | United Kingdom |
SO50014_1 | Germany | Germany | Germany |
SO50015_1 | Germany | Germany | Germany |
SO50016_1 | Germany | Germany | Germany |
SO50017_1 | United Kingdom | United Kingdom | United Kingdom |
SO50018_1 | Germany | Germany | Germany |
SO50019_1 | Canada | Canada | Canada |
SO50020_1 | Germany | Germany | Germany |
SO50021_1 | United Kingdom | United Kingdom | United Kingdom |
SO50022_1 | Germany | Germany | Germany |
SO50023_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50024_1 | Canada | Canada | Canada |
SO50025_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50026_1 | Australia | Australia | Australia |
SO50027_1 | Australia | Australia | Australia |
SO50028_1 | Australia | Australia | Australia |
SO50029_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50030_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50031_1 | France | France | France |
SO50032_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50033_1 | Germany | Germany | Germany |
SO50034_1 | Australia | Australia | Australia |
SO50035_1 | Australia | Australia | Australia |
SO50036_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50037_1 | France | France | France |
SO50038_1 | Germany | Germany | Germany |
SO50039_1 | United Kingdom | United Kingdom | United Kingdom |
SO50040_1 | Australia | Australia | Australia |
SO50041_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50042_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50043_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50044_1 | Australia | Australia | Australia |
SO50045_1 | Australia | Australia | Australia |
SO50046_1 | France | France | France |
SO50047_1 | France | France | France |
SO50048_1 | Germany | Germany | Germany |
SO50049_1 | United Kingdom | United Kingdom | United Kingdom |
SO50050_1 | Australia | Australia | Australia |
SO50051_1 | Australia | Australia | Australia |
SO50052_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50053_1 | Germany | Germany | Germany |
SO50054_1 | France | France | France |
SO50055_1 | United Kingdom | United Kingdom | United Kingdom |
SO50056_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50057_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50122_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50123_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50124_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50125_1 | Australia | Australia | Australia |
SO50126_1 | Australia | Australia | Australia |
SO50127_1 | Australia | Australia | Australia |
SO50128_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50129_1 | United Kingdom | United Kingdom | United Kingdom |
SO50066_1 | Australia | Australia | Australia |
SO50067_1 | Australia | Australia | Australia |
SO50068_1 | Australia | Australia | Australia |
SO50069_1 | United Kingdom | United Kingdom | United Kingdom |
SO50070_1 | Germany | Germany | Germany |
SO50071_1 | United Kingdom | United Kingdom | United Kingdom |
SO50072_1 | Australia | Australia | Australia |
SO50073_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50074_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50075_1 | Australia | Australia | Australia |
SO50076_1 | Australia | Australia | Australia |
SO50077_1 | Australia | Australia | Australia |
SO50078_1 | Australia | Australia | Australia |
SO50079_1 | Australia | Australia | Australia |
SO50080_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50081_1 | France | France | France |
SO50082_1 | Germany | Germany | Germany |
SO50083_1 | France | France | France |
SO50084_1 | Germany | Germany | Germany |
SO50085_1 | Australia | Australia | Australia |
SO50086_1 | Australia | Australia | Australia |
SO50087_1 | Canada | Canada | Canada |
SO50088_1 | France | France | France |
SO50089_1 | France | France | France |
SO50090_1 | France | France | France |
SO50091_1 | France | France | France |
SO50092_1 | France | France | France |
SO50093_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50094_1 | Australia | Australia | Australia |
SO50095_1 | Australia | Australia | Australia |
SO50096_1 | United Kingdom | United Kingdom | United Kingdom |
SO50097_1 | France | France | France |
SO50098_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50099_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50100_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50101_1 | France | France | France |
SO50102_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50103_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50104_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50105_1 | Australia | Australia | Australia |
SO50106_1 | Australia | Australia | Australia |
SO50107_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50108_1 | United Kingdom | United Kingdom | United Kingdom |
SO50109_1 | France | France | France |
SO50110_1 | France | France | France |
SO50111_1 | Australia | Australia | Australia |
SO50112_1 | Australia | Australia | Australia |
SO50113_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50114_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50115_1 | Germany | Germany | Germany |
SO50116_1 | Germany | Germany | Germany |
SO50117_1 | Germany | Germany | Germany |
SO50118_1 | United Kingdom | United Kingdom | United Kingdom |
SO50119_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50120_1 | Australia | Australia | Australia |
SO50121_1 | Australia | Australia | Australia |
SO50186_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50187_1 | Australia | Australia | Australia |
SO50188_1 | Australia | Australia | Australia |
SO50323_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50324_1 | United Kingdom | United Kingdom | United Kingdom |
SO50325_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50326_1 | Canada | Canada | Canada |
SO50327_1 | United Kingdom | United Kingdom | United Kingdom |
SO49182_1 | Germany | Germany | Germany |
SO49183_1 | Germany | Germany | Germany |
SO49184_1 | Australia | Australia | Australia |
SO49185_1 | Australia | Australia | Australia |
SO49186_1 | Australia | Australia | Australia |
SO49187_1 | Australia | Australia | Australia |
SO49188_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49189_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49190_1 | Australia | Australia | Australia |
SO49191_1 | United Kingdom | United Kingdom | United Kingdom |
SO49192_1 | Germany | Germany | Germany |
SO49193_1 | France | France | France |
SO49194_1 | United Kingdom | United Kingdom | United Kingdom |
SO49195_1 | Germany | Germany | Germany |
SO49196_1 | Germany | Germany | Germany |
SO49197_1 | France | France | France |
SO49198_1 | Australia | Australia | Australia |
SO49199_1 | Australia | Australia | Australia |
SO49200_1 | United Kingdom | United Kingdom | United Kingdom |
SO49201_1 | United Kingdom | United Kingdom | United Kingdom |
SO49202_1 | United Kingdom | United Kingdom | United Kingdom |
SO49203_1 | France | France | France |
SO49204_1 | Australia | Australia | Australia |
SO49205_1 | Australia | Australia | Australia |
SO49206_1 | Australia | Australia | Australia |
SO49207_1 | Australia | Australia | Australia |
SO49208_1 | Australia | Australia | Australia |
SO49209_1 | Australia | Australia | Australia |
SO49210_1 | Canada | Canada | Canada |
SO49211_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49212_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49213_1 | Australia | Australia | Australia |
SO49214_1 | Australia | Australia | Australia |
SO49215_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49216_1 | Australia | Australia | Australia |
SO49217_1 | France | France | France |
SO49218_1 | Canada | Canada | Canada |
SO49219_1 | United Kingdom | United Kingdom | United Kingdom |
SO49220_1 | Australia | Australia | Australia |
SO49221_1 | Australia | Australia | Australia |
SO49222_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49223_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49224_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49225_1 | Germany | Germany | Germany |
SO49226_1 | United Kingdom | United Kingdom | United Kingdom |
SO49227_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49228_1 | France | France | France |
SO49229_1 | Germany | Germany | Germany |
SO49230_1 | Canada | Canada | Canada |
SO49231_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49232_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49233_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49234_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO49235_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO49236_1 | Australia | Australia | Australia |
SO49237_1 | Australia | Australia | Australia |
SO50384_1 | Australia | Australia | Australia |
SO50385_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50386_1 | Germany | Germany | Germany |
SO50387_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50388_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50389_1 | Germany | Germany | Germany |
SO50390_1 | United Kingdom | United Kingdom | United Kingdom |
SO50391_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50130_1 | Germany | Germany | Germany |
SO50131_1 | France | France | France |
SO50132_1 | United Kingdom | United Kingdom | United Kingdom |
SO50133_1 | France | France | France |
SO50134_1 | Australia | Australia | Australia |
SO50135_1 | Australia | Australia | Australia |
SO50136_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50137_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50138_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50139_1 | Australia | Australia | Australia |
SO50140_1 | Australia | Australia | Australia |
SO50141_1 | Australia | Australia | Australia |
SO50142_1 | Australia | Australia | Australia |
SO50143_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50144_1 | United Kingdom | United Kingdom | United Kingdom |
SO50145_1 | Germany | Germany | Germany |
SO50146_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50147_1 | Canada | Canada | Canada |
SO50148_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50149_1 | Australia | Australia | Australia |
SO50150_1 | Australia | Australia | Australia |
SO50151_1 | Australia | Australia | Australia |
SO50152_1 | Germany | Germany | Germany |
SO50153_1 | United Kingdom | United Kingdom | United Kingdom |
SO50154_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50155_1 | Australia | Australia | Australia |
SO50156_1 | Australia | Australia | Australia |
SO50157_1 | Australia | Australia | Australia |
SO50158_1 | Australia | Australia | Australia |
SO50159_1 | Australia | Australia | Australia |
SO50160_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50161_1 | Australia | Australia | Australia |
SO50162_1 | Australia | Australia | Australia |
SO50163_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50164_1 | Germany | Germany | Germany |
SO50165_1 | United Kingdom | United Kingdom | United Kingdom |
SO50166_1 | United Kingdom | United Kingdom | United Kingdom |
SO50167_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50168_1 | Australia | Australia | Australia |
SO50169_1 | Australia | Australia | Australia |
SO50170_1 | Australia | Australia | Australia |
SO50171_1 | France | France | France |
SO50172_1 | France | France | France |
SO50173_1 | Australia | Australia | Australia |
Generated 2025-07-04 17:37:50.601 UTC