[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5601 > < TAKE 240 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
240 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO50910_1 | Germany | Germany | Germany |
SO50911_1 | Germany | Germany | Germany |
SO50912_1 | Australia | Australia | Australia |
SO50913_1 | Australia | Australia | Australia |
SO50914_1 | Australia | Australia | Australia |
SO50915_1 | Australia | Australia | Australia |
SO50916_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO50917_1 | France | France | France |
SO50918_1 | France | France | France |
SO50919_1 | Germany | Germany | Germany |
SO50920_1 | France | France | France |
SO50921_1 | United Kingdom | United Kingdom | United Kingdom |
SO50922_1 | Germany | Germany | Germany |
SO50923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO50924_1 | Australia | Australia | Australia |
SO50925_1 | Australia | Australia | Australia |
SO50926_1 | Australia | Australia | Australia |
SO50927_1 | Australia | Australia | Australia |
SO50928_1 | Australia | Australia | Australia |
SO50929_1 | Australia | Australia | Australia |
SO50930_1 | France | France | France |
SO50931_1 | France | France | France |
SO50932_1 | France | France | France |
SO50933_1 | France | France | France |
SO51308_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51308_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51308_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51309_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51309_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51309_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51309_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51310_1 | Canada | Canada | Canada |
SO51241_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51242_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51243_1 | United Kingdom | United Kingdom | United Kingdom |
SO51243_2 | United Kingdom | United Kingdom | United Kingdom |
SO51243_3 | United Kingdom | United Kingdom | United Kingdom |
SO51244_1 | Germany | Germany | Germany |
SO51244_2 | Germany | Germany | Germany |
SO51244_3 | Germany | Germany | Germany |
SO51244_4 | Germany | Germany | Germany |
SO51245_1 | France | France | France |
SO51245_2 | France | France | France |
SO51245_3 | France | France | France |
SO51246_1 | Germany | Germany | Germany |
SO51246_2 | Germany | Germany | Germany |
SO51246_3 | Germany | Germany | Germany |
SO51246_4 | Germany | Germany | Germany |
SO51247_1 | Germany | Germany | Germany |
SO51247_2 | Germany | Germany | Germany |
SO51247_3 | Germany | Germany | Germany |
SO51248_1 | France | France | France |
SO51249_1 | United Kingdom | United Kingdom | United Kingdom |
SO51249_2 | United Kingdom | United Kingdom | United Kingdom |
SO51249_3 | United Kingdom | United Kingdom | United Kingdom |
SO51250_1 | United Kingdom | United Kingdom | United Kingdom |
SO51250_2 | United Kingdom | United Kingdom | United Kingdom |
SO51250_3 | United Kingdom | United Kingdom | United Kingdom |
SO51250_4 | United Kingdom | United Kingdom | United Kingdom |
SO51251_1 | France | France | France |
SO51252_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51252_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51252_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51253_1 | Canada | Canada | Canada |
SO51253_2 | Canada | Canada | Canada |
SO51254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51254_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51254_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51254_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51255_1 | Australia | Australia | Australia |
SO51255_2 | Australia | Australia | Australia |
SO51255_3 | Australia | Australia | Australia |
SO51256_1 | Australia | Australia | Australia |
SO51256_2 | Australia | Australia | Australia |
SO51257_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51258_1 | Canada | Canada | Canada |
SO51258_2 | Canada | Canada | Canada |
SO51259_1 | France | France | France |
SO51259_2 | France | France | France |
SO51259_3 | France | France | France |
SO51259_4 | France | France | France |
SO51259_5 | France | France | France |
SO51260_1 | Germany | Germany | Germany |
SO51260_2 | Germany | Germany | Germany |
SO51260_3 | Germany | Germany | Germany |
SO51261_1 | United Kingdom | United Kingdom | United Kingdom |
SO51332_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51333_1 | United Kingdom | United Kingdom | United Kingdom |
SO51333_2 | United Kingdom | United Kingdom | United Kingdom |
SO51333_3 | United Kingdom | United Kingdom | United Kingdom |
SO51334_1 | France | France | France |
SO51334_2 | France | France | France |
SO51335_1 | France | France | France |
SO51335_2 | France | France | France |
SO51216_3 | Australia | Australia | Australia |
SO51216_4 | Australia | Australia | Australia |
SO51216_5 | Australia | Australia | Australia |
SO51217_1 | Australia | Australia | Australia |
SO51217_2 | Australia | Australia | Australia |
SO51217_3 | Australia | Australia | Australia |
SO51217_4 | Australia | Australia | Australia |
SO51218_1 | Australia | Australia | Australia |
SO51219_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51219_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51220_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51220_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51221_1 | Germany | Germany | Germany |
SO51221_2 | Germany | Germany | Germany |
SO51221_3 | Germany | Germany | Germany |
SO51222_1 | United Kingdom | United Kingdom | United Kingdom |
SO51222_2 | United Kingdom | United Kingdom | United Kingdom |
SO51223_1 | Germany | Germany | Germany |
SO51223_2 | Germany | Germany | Germany |
SO51223_3 | Germany | Germany | Germany |
SO51223_4 | Germany | Germany | Germany |
SO51224_1 | France | France | France |
SO51224_2 | France | France | France |
SO51225_1 | United Kingdom | United Kingdom | United Kingdom |
SO51225_2 | United Kingdom | United Kingdom | United Kingdom |
SO51225_3 | United Kingdom | United Kingdom | United Kingdom |
SO51226_1 | United Kingdom | United Kingdom | United Kingdom |
SO51226_2 | United Kingdom | United Kingdom | United Kingdom |
SO51227_1 | Germany | Germany | Germany |
SO51227_2 | Germany | Germany | Germany |
SO51227_3 | Germany | Germany | Germany |
SO51228_1 | France | France | France |
SO51228_2 | France | France | France |
SO51228_3 | France | France | France |
SO51228_4 | France | France | France |
SO51228_5 | France | France | France |
SO51229_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51230_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51231_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51232_1 | United Kingdom | United Kingdom | United Kingdom |
SO51232_2 | United Kingdom | United Kingdom | United Kingdom |
SO51233_1 | Australia | Australia | Australia |
SO51234_1 | Australia | Australia | Australia |
SO51234_2 | Australia | Australia | Australia |
SO51235_1 | Australia | Australia | Australia |
SO51236_1 | Australia | Australia | Australia |
SO51237_1 | Australia | Australia | Australia |
SO51237_2 | Australia | Australia | Australia |
SO51237_3 | Australia | Australia | Australia |
SO51355_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51355_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51355_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51356_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51356_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51356_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51357_1 | Germany | Germany | Germany |
SO51357_2 | Germany | Germany | Germany |
SO51357_3 | Germany | Germany | Germany |
SO51286_1 | United Kingdom | United Kingdom | United Kingdom |
SO51336_1 | Australia | Australia | Australia |
SO51358_1 | Germany | Germany | Germany |
SO51286_2 | United Kingdom | United Kingdom | United Kingdom |
SO51336_2 | Australia | Australia | Australia |
SO51358_2 | Germany | Germany | Germany |
SO51286_3 | United Kingdom | United Kingdom | United Kingdom |
SO51336_3 | Australia | Australia | Australia |
SO51358_3 | Germany | Germany | Germany |
SO51286_4 | United Kingdom | United Kingdom | United Kingdom |
SO51337_1 | Australia | Australia | Australia |
SO51358_4 | Germany | Germany | Germany |
SO51287_1 | Germany | Germany | Germany |
SO51338_1 | Australia | Australia | Australia |
SO51359_1 | Australia | Australia | Australia |
SO51287_2 | Germany | Germany | Germany |
SO51339_1 | Germany | Germany | Germany |
SO51359_2 | Australia | Australia | Australia |
SO51287_3 | Germany | Germany | Germany |
SO51339_2 | Germany | Germany | Germany |
SO51359_3 | Australia | Australia | Australia |
SO51288_1 | Germany | Germany | Germany |
SO51339_3 | Germany | Germany | Germany |
SO51359_4 | Australia | Australia | Australia |
SO51288_2 | Germany | Germany | Germany |
SO51339_4 | Germany | Germany | Germany |
SO51359_5 | Australia | Australia | Australia |
SO51288_3 | Germany | Germany | Germany |
SO51340_1 | Germany | Germany | Germany |
SO51360_1 | United Kingdom | United Kingdom | United Kingdom |
SO51289_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51340_2 | Germany | Germany | Germany |
SO51360_2 | United Kingdom | United Kingdom | United Kingdom |
SO51289_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51341_1 | France | France | France |
SO51360_3 | United Kingdom | United Kingdom | United Kingdom |
SO51290_1 | Australia | Australia | Australia |
SO51341_2 | France | France | France |
SO51360_4 | United Kingdom | United Kingdom | United Kingdom |
SO51290_2 | Australia | Australia | Australia |
SO51341_3 | France | France | France |
SO51361_1 | Germany | Germany | Germany |
SO51291_1 | Australia | Australia | Australia |
SO51341_4 | France | France | France |
SO51361_2 | Germany | Germany | Germany |
SO51291_2 | Australia | Australia | Australia |
SO51342_1 | United Kingdom | United Kingdom | United Kingdom |
SO51361_3 | Germany | Germany | Germany |
SO51291_3 | Australia | Australia | Australia |
SO51342_2 | United Kingdom | United Kingdom | United Kingdom |
SO51361_4 | Germany | Germany | Germany |
SO51292_1 | Australia | Australia | Australia |
SO51343_1 | France | France | France |
SO51362_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51292_2 | Australia | Australia | Australia |
SO51343_2 | France | France | France |
SO51362_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51293_1 | Australia | Australia | Australia |
SO51343_3 | France | France | France |
SO51362_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51294_1 | Australia | Australia | Australia |
SO51344_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51362_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51294_2 | Australia | Australia | Australia |
SO51344_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51363_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51294_3 | Australia | Australia | Australia |
SO51344_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51363_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51295_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51344_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51363_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51295_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51344_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51364_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51296_1 | Germany | Germany | Germany |
SO51345_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51365_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51296_2 | Germany | Germany | Germany |
Generated 2025-07-08 12:54:20.534 UTC