[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 7621 > < TAKE 224 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
224 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO52208_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52208_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52209_1 | France | France | France |
SO52209_2 | France | France | France |
SO52209_3 | France | France | France |
SO52209_4 | France | France | France |
SO52210_1 | Australia | Australia | Australia |
SO52210_2 | Australia | Australia | Australia |
SO52210_3 | Australia | Australia | Australia |
SO52210_4 | Australia | Australia | Australia |
SO52211_1 | Australia | Australia | Australia |
SO52211_2 | Australia | Australia | Australia |
SO52212_1 | Australia | Australia | Australia |
SO52213_1 | France | France | France |
SO52213_2 | France | France | France |
SO52213_3 | France | France | France |
SO52213_4 | France | France | France |
SO52214_1 | France | France | France |
SO52214_2 | France | France | France |
SO52215_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52216_1 | Australia | Australia | Australia |
SO52216_2 | Australia | Australia | Australia |
SO52217_1 | Australia | Australia | Australia |
SO52217_2 | Australia | Australia | Australia |
SO52217_3 | Australia | Australia | Australia |
SO52217_4 | Australia | Australia | Australia |
SO52218_1 | Australia | Australia | Australia |
SO52218_2 | Australia | Australia | Australia |
SO52219_1 | Australia | Australia | Australia |
SO52219_2 | Australia | Australia | Australia |
SO52220_1 | Australia | Australia | Australia |
SO52220_2 | Australia | Australia | Australia |
SO52220_3 | Australia | Australia | Australia |
SO52221_1 | Australia | Australia | Australia |
SO52222_1 | Germany | Germany | Germany |
SO52222_2 | Germany | Germany | Germany |
SO52222_3 | Germany | Germany | Germany |
SO52223_1 | United Kingdom | United Kingdom | United Kingdom |
SO52223_2 | United Kingdom | United Kingdom | United Kingdom |
SO52223_3 | United Kingdom | United Kingdom | United Kingdom |
SO52223_4 | United Kingdom | United Kingdom | United Kingdom |
SO52224_1 | United Kingdom | United Kingdom | United Kingdom |
SO52224_2 | United Kingdom | United Kingdom | United Kingdom |
SO52225_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52225_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52225_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52226_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52226_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52226_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52227_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52227_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52228_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52229_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52230_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52231_1 | Canada | Canada | Canada |
SO52232_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52232_5 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52233_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52233_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52234_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52235_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52236_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52236_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52236_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52237_1 | Canada | Canada | Canada |
SO52237_2 | Canada | Canada | Canada |
SO52237_3 | Canada | Canada | Canada |
SO52238_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52238_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52239_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52240_1 | Canada | Canada | Canada |
SO52240_2 | Canada | Canada | Canada |
SO52241_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52241_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52242_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52243_1 | Canada | Canada | Canada |
SO52243_2 | Canada | Canada | Canada |
SO52243_3 | Canada | Canada | Canada |
SO52244_1 | Canada | Canada | Canada |
SO52244_2 | Canada | Canada | Canada |
SO52244_3 | Canada | Canada | Canada |
SO52245_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52245_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52245_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52246_1 | France | France | France |
SO52246_2 | France | France | France |
SO52246_3 | France | France | France |
SO52247_1 | France | France | France |
SO52248_1 | France | France | France |
SO52248_2 | France | France | France |
SO52248_3 | France | France | France |
SO52248_4 | France | France | France |
SO52248_5 | France | France | France |
SO52249_1 | Canada | Canada | Canada |
SO52249_2 | Canada | Canada | Canada |
SO52250_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52250_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52251_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52251_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52252_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_1 | United Kingdom | United Kingdom | United Kingdom |
SO52253_2 | United Kingdom | United Kingdom | United Kingdom |
SO52253_3 | United Kingdom | United Kingdom | United Kingdom |
SO52254_1 | United Kingdom | United Kingdom | United Kingdom |
SO52254_2 | United Kingdom | United Kingdom | United Kingdom |
SO52255_1 | France | France | France |
SO52255_2 | France | France | France |
SO52255_3 | France | France | France |
SO52256_1 | United Kingdom | United Kingdom | United Kingdom |
SO52256_2 | United Kingdom | United Kingdom | United Kingdom |
SO52257_1 | France | France | France |
SO52257_2 | France | France | France |
SO52257_3 | France | France | France |
SO52258_1 | United Kingdom | United Kingdom | United Kingdom |
SO52258_2 | United Kingdom | United Kingdom | United Kingdom |
SO52259_1 | United Kingdom | United Kingdom | United Kingdom |
SO52259_2 | United Kingdom | United Kingdom | United Kingdom |
SO52260_1 | Germany | Germany | Germany |
SO52260_2 | Germany | Germany | Germany |
SO52260_3 | Germany | Germany | Germany |
SO52261_1 | Canada | Canada | Canada |
SO52261_2 | Canada | Canada | Canada |
SO52261_3 | Canada | Canada | Canada |
SO52262_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52262_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52262_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52263_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52263_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52264_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52264_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52264_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52265_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52265_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52265_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52266_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52266_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52267_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52267_2 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52267_3 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52267_4 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52267_5 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52268_1 | France | France | France |
SO52268_2 | France | France | France |
SO52268_3 | France | France | France |
SO52269_1 | Australia | Australia | Australia |
SO52270_1 | Australia | Australia | Australia |
SO52270_2 | Australia | Australia | Australia |
SO52270_3 | Australia | Australia | Australia |
SO52270_4 | Australia | Australia | Australia |
SO52271_1 | Australia | Australia | Australia |
SO52271_2 | Australia | Australia | Australia |
SO52271_3 | Australia | Australia | Australia |
SO52271_4 | Australia | Australia | Australia |
SO52272_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52272_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52272_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52273_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52273_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52273_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52273_4 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52274_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52274_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52274_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_2 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52275_3 | United States, Southwest | United States, Southwest | United States, Southwest |
SO52276_1 | France | France | France |
SO52276_2 | France | France | France |
SO52276_3 | France | France | France |
SO52276_4 | France | France | France |
SO52276_5 | France | France | France |
SO52277_1 | France | France | France |
SO52277_2 | France | France | France |
SO52277_3 | France | France | France |
SO52277_4 | France | France | France |
SO52278_1 | Australia | Australia | Australia |
SO52278_2 | Australia | Australia | Australia |
SO52278_3 | Australia | Australia | Australia |
SO52278_4 | Australia | Australia | Australia |
SO52279_1 | Australia | Australia | Australia |
SO52279_2 | Australia | Australia | Australia |
SO52279_3 | Australia | Australia | Australia |
SO52279_4 | Australia | Australia | Australia |
SO52280_1 | Australia | Australia | Australia |
SO52280_2 | Australia | Australia | Australia |
SO52280_3 | Australia | Australia | Australia |
SO52280_4 | Australia | Australia | Australia |
SO52281_1 | Australia | Australia | Australia |
SO52281_2 | Australia | Australia | Australia |
SO52281_3 | Australia | Australia | Australia |
SO52281_4 | Australia | Australia | Australia |
SO52282_1 | United Kingdom | United Kingdom | United Kingdom |
SO52282_2 | United Kingdom | United Kingdom | United Kingdom |
SO52283_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52284_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO52285_1 | Australia | Australia | Australia |
SO52285_2 | Australia | Australia | Australia |
SO52285_3 | Australia | Australia | Australia |
SO52286_1 | Australia | Australia | Australia |
SO52286_2 | Australia | Australia | Australia |
SO52286_3 | Australia | Australia | Australia |
SO52286_4 | Australia | Australia | Australia |
SO52286_5 | Australia | Australia | Australia |
SO52287_1 | Australia | Australia | Australia |
SO52287_2 | Australia | Australia | Australia |
SO52287_3 | Australia | Australia | Australia |
SO52288_1 | Australia | Australia | Australia |
SO52289_1 | Australia | Australia | Australia |
SO52289_2 | Australia | Australia | Australia |
Generated 2025-07-10 12:51:08.845 UTC