[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 5624 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO51244_1 | Germany | Germany | Germany |
SO51265_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51265_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51266_1 | Australia | Australia | Australia |
SO51267_1 | Australia | Australia | Australia |
SO51267_2 | Australia | Australia | Australia |
SO51267_3 | Australia | Australia | Australia |
SO51267_4 | Australia | Australia | Australia |
SO51267_5 | Australia | Australia | Australia |
SO51267_6 | Australia | Australia | Australia |
SO51246_3 | Germany | Germany | Germany |
SO51268_1 | Australia | Australia | Australia |
SO51246_4 | Germany | Germany | Germany |
SO51268_2 | Australia | Australia | Australia |
SO51247_1 | Germany | Germany | Germany |
SO51269_1 | Australia | Australia | Australia |
SO51247_2 | Germany | Germany | Germany |
SO51269_2 | Australia | Australia | Australia |
SO51247_3 | Germany | Germany | Germany |
SO51269_3 | Australia | Australia | Australia |
SO51248_1 | France | France | France |
SO51269_4 | Australia | Australia | Australia |
SO51249_1 | United Kingdom | United Kingdom | United Kingdom |
SO51270_1 | United Kingdom | United Kingdom | United Kingdom |
SO51249_2 | United Kingdom | United Kingdom | United Kingdom |
SO51270_2 | United Kingdom | United Kingdom | United Kingdom |
SO51249_3 | United Kingdom | United Kingdom | United Kingdom |
SO51270_3 | United Kingdom | United Kingdom | United Kingdom |
SO51250_1 | United Kingdom | United Kingdom | United Kingdom |
SO51271_1 | Germany | Germany | Germany |
SO51250_2 | United Kingdom | United Kingdom | United Kingdom |
SO51271_2 | Germany | Germany | Germany |
SO51250_3 | United Kingdom | United Kingdom | United Kingdom |
SO51271_3 | Germany | Germany | Germany |
SO51250_4 | United Kingdom | United Kingdom | United Kingdom |
SO51271_4 | Germany | Germany | Germany |
SO51251_1 | France | France | France |
SO51272_1 | United Kingdom | United Kingdom | United Kingdom |
SO51252_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51272_2 | United Kingdom | United Kingdom | United Kingdom |
SO51252_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51273_1 | United Kingdom | United Kingdom | United Kingdom |
SO51252_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51273_2 | United Kingdom | United Kingdom | United Kingdom |
SO51253_1 | Canada | Canada | Canada |
SO51274_1 | Germany | Germany | Germany |
SO51253_2 | Canada | Canada | Canada |
SO51274_2 | Germany | Germany | Germany |
SO51254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51274_3 | Germany | Germany | Germany |
SO51254_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51275_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51254_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51275_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51254_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51275_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51255_1 | Australia | Australia | Australia |
SO51276_1 | Canada | Canada | Canada |
SO51255_2 | Australia | Australia | Australia |
SO51276_2 | Canada | Canada | Canada |
SO51255_3 | Australia | Australia | Australia |
SO51276_3 | Canada | Canada | Canada |
SO51256_1 | Australia | Australia | Australia |
SO51277_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51256_2 | Australia | Australia | Australia |
SO51277_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51257_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51278_1 | Germany | Germany | Germany |
SO51258_1 | Canada | Canada | Canada |
SO51278_2 | Germany | Germany | Germany |
SO51258_2 | Canada | Canada | Canada |
SO51278_3 | Germany | Germany | Germany |
SO51259_1 | France | France | France |
SO51279_1 | Germany | Germany | Germany |
SO51259_2 | France | France | France |
SO51279_2 | Germany | Germany | Germany |
SO51259_3 | France | France | France |
SO51280_1 | Australia | Australia | Australia |
SO51259_4 | France | France | France |
SO51280_2 | Australia | Australia | Australia |
SO51259_5 | France | France | France |
SO51281_1 | Australia | Australia | Australia |
SO51260_1 | Germany | Germany | Germany |
SO51282_1 | Australia | Australia | Australia |
SO51260_2 | Germany | Germany | Germany |
SO51282_2 | Australia | Australia | Australia |
SO51260_3 | Germany | Germany | Germany |
SO51282_3 | Australia | Australia | Australia |
SO51261_1 | United Kingdom | United Kingdom | United Kingdom |
SO51282_4 | Australia | Australia | Australia |
SO51261_2 | United Kingdom | United Kingdom | United Kingdom |
SO51283_1 | Canada | Canada | Canada |
SO51262_1 | France | France | France |
SO51283_2 | Canada | Canada | Canada |
SO51262_2 | France | France | France |
SO51283_3 | Canada | Canada | Canada |
SO51262_3 | France | France | France |
SO51284_1 | United Kingdom | United Kingdom | United Kingdom |
SO51262_4 | France | France | France |
SO51284_2 | United Kingdom | United Kingdom | United Kingdom |
SO51263_1 | United Kingdom | United Kingdom | United Kingdom |
SO51285_1 | Germany | Germany | Germany |
SO51263_2 | United Kingdom | United Kingdom | United Kingdom |
SO51285_2 | Germany | Germany | Germany |
SO51263_3 | United Kingdom | United Kingdom | United Kingdom |
SO51286_1 | United Kingdom | United Kingdom | United Kingdom |
SO51263_4 | United Kingdom | United Kingdom | United Kingdom |
SO51286_2 | United Kingdom | United Kingdom | United Kingdom |
SO51264_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51286_3 | United Kingdom | United Kingdom | United Kingdom |
SO51264_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51286_4 | United Kingdom | United Kingdom | United Kingdom |
SO51264_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51287_1 | Germany | Germany | Germany |
SO51264_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51287_2 | Germany | Germany | Germany |
SO51264_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51287_3 | Germany | Germany | Germany |
SO51265_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51288_1 | Germany | Germany | Germany |
SO51265_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51314_1 | Australia | Australia | Australia |
SO51288_2 | Germany | Germany | Germany |
SO51314_2 | Australia | Australia | Australia |
SO51288_3 | Germany | Germany | Germany |
SO51314_3 | Australia | Australia | Australia |
SO51289_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51315_1 | Australia | Australia | Australia |
SO51289_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51315_2 | Australia | Australia | Australia |
SO51290_1 | Australia | Australia | Australia |
SO51315_3 | Australia | Australia | Australia |
SO51290_2 | Australia | Australia | Australia |
SO51315_4 | Australia | Australia | Australia |
SO51291_1 | Australia | Australia | Australia |
SO51316_1 | France | France | France |
SO51291_2 | Australia | Australia | Australia |
SO51316_2 | France | France | France |
SO51316_3 | France | France | France |
SO51317_1 | France | France | France |
SO51317_2 | France | France | France |
SO51317_3 | France | France | France |
SO51318_1 | Germany | Germany | Germany |
SO51318_2 | Germany | Germany | Germany |
SO51318_3 | Germany | Germany | Germany |
SO51318_4 | Germany | Germany | Germany |
SO51319_1 | France | France | France |
SO51319_2 | France | France | France |
SO51319_3 | France | France | France |
SO51320_1 | France | France | France |
SO51320_2 | France | France | France |
SO51321_1 | Australia | Australia | Australia |
SO51321_2 | Australia | Australia | Australia |
SO51322_1 | France | France | France |
SO51322_2 | France | France | France |
SO51323_1 | Germany | Germany | Germany |
SO51323_2 | Germany | Germany | Germany |
SO51324_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51325_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51326_1 | France | France | France |
SO51326_2 | France | France | France |
SO51327_1 | Australia | Australia | Australia |
SO51327_2 | Australia | Australia | Australia |
SO51327_3 | Australia | Australia | Australia |
SO51327_4 | Australia | Australia | Australia |
SO51328_1 | Australia | Australia | Australia |
SO51329_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51329_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51330_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51330_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51331_2 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO51336_1 | Australia | Australia | Australia |
SO51336_2 | Australia | Australia | Australia |
SO51336_3 | Australia | Australia | Australia |
SO51337_1 | Australia | Australia | Australia |
SO51338_1 | Australia | Australia | Australia |
SO51339_1 | Germany | Germany | Germany |
SO51339_2 | Germany | Germany | Germany |
SO51339_3 | Germany | Germany | Germany |
SO51339_4 | Germany | Germany | Germany |
SO51340_1 | Germany | Germany | Germany |
SO51340_2 | Germany | Germany | Germany |
SO51341_1 | France | France | France |
SO51341_2 | France | France | France |
SO51341_3 | France | France | France |
SO51341_4 | France | France | France |
SO51342_1 | United Kingdom | United Kingdom | United Kingdom |
SO51291_3 | Australia | Australia | Australia |
SO51292_1 | Australia | Australia | Australia |
SO51292_2 | Australia | Australia | Australia |
SO51293_1 | Australia | Australia | Australia |
SO51294_1 | Australia | Australia | Australia |
SO51294_2 | Australia | Australia | Australia |
SO51294_3 | Australia | Australia | Australia |
SO51295_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51295_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO51296_1 | Germany | Germany | Germany |
SO51296_2 | Germany | Germany | Germany |
SO51297_1 | Germany | Germany | Germany |
SO51297_2 | Germany | Germany | Germany |
SO51297_3 | Germany | Germany | Germany |
SO51297_4 | Germany | Germany | Germany |
SO51298_1 | United Kingdom | United Kingdom | United Kingdom |
SO51298_2 | United Kingdom | United Kingdom | United Kingdom |
SO51298_3 | United Kingdom | United Kingdom | United Kingdom |
SO51299_1 | Germany | Germany | Germany |
SO51299_2 | Germany | Germany | Germany |
SO51300_1 | Australia | Australia | Australia |
SO51301_1 | Australia | Australia | Australia |
SO51301_2 | Australia | Australia | Australia |
SO51302_1 | France | France | France |
SO51302_2 | France | France | France |
SO51303_1 | Germany | Germany | Germany |
SO51303_2 | Germany | Germany | Germany |
SO51303_3 | Germany | Germany | Germany |
SO51304_1 | United Kingdom | United Kingdom | United Kingdom |
SO51304_2 | United Kingdom | United Kingdom | United Kingdom |
SO51305_1 | France | France | France |
SO51306_1 | United Kingdom | United Kingdom | United Kingdom |
SO51306_2 | United Kingdom | United Kingdom | United Kingdom |
SO51306_3 | United Kingdom | United Kingdom | United Kingdom |
SO51307_1 | France | France | France |
SO51307_2 | France | France | France |
SO51307_3 | France | France | France |
SO51307_4 | France | France | France |
SO51308_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO51308_2 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
Generated 2025-07-04 17:28:33.868 UTC