[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 312 > < TAKE 124 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
124 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44230_1 | Australia | Australia | Australia |
SO44214_1 | Australia | Australia | Australia |
SO44150_1 | Australia | Australia | Australia |
SO44231_1 | France | France | France |
SO44215_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44151_1 | Australia | Australia | Australia |
SO44232_1 | Australia | Australia | Australia |
SO44216_1 | Germany | Germany | Germany |
SO44152_1 | United Kingdom | United Kingdom | United Kingdom |
SO44169_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44170_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44171_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44172_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44173_1 | United Kingdom | United Kingdom | United Kingdom |
SO44174_1 | Australia | Australia | Australia |
SO44175_1 | Australia | Australia | Australia |
SO44176_1 | France | France | France |
SO44177_1 | United Kingdom | United Kingdom | United Kingdom |
SO44178_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44179_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44180_1 | Australia | Australia | Australia |
SO44181_1 | Australia | Australia | Australia |
SO44182_1 | Australia | Australia | Australia |
SO44183_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44184_1 | Australia | Australia | Australia |
SO44201_1 | France | France | France |
SO44202_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44203_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44204_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44205_1 | Australia | Australia | Australia |
SO44206_1 | United Kingdom | United Kingdom | United Kingdom |
SO44207_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44208_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44241_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44242_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44243_1 | Australia | Australia | Australia |
SO44244_1 | Australia | Australia | Australia |
SO44245_1 | Australia | Australia | Australia |
SO44246_1 | France | France | France |
SO44247_1 | Australia | Australia | Australia |
SO44248_1 | Australia | Australia | Australia |
SO44249_1 | United Kingdom | United Kingdom | United Kingdom |
SO44250_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44251_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44252_1 | United Kingdom | United Kingdom | United Kingdom |
SO44253_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44254_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44255_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44256_1 | Australia | Australia | Australia |
SO44257_1 | France | France | France |
SO44258_1 | Germany | Germany | Germany |
SO44259_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44260_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44261_1 | Canada | Canada | Canada |
SO44262_1 | United Kingdom | United Kingdom | United Kingdom |
SO44263_1 | Australia | Australia | Australia |
SO44264_1 | Australia | Australia | Australia |
SO44337_1 | Australia | Australia | Australia |
SO44338_1 | Australia | Australia | Australia |
SO44339_1 | Australia | Australia | Australia |
SO44340_1 | Australia | Australia | Australia |
SO44341_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44342_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44343_1 | Australia | Australia | Australia |
SO44344_1 | United Kingdom | United Kingdom | United Kingdom |
SO44345_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44346_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44347_1 | Australia | Australia | Australia |
SO44348_1 | United Kingdom | United Kingdom | United Kingdom |
SO44349_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44350_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44351_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44352_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43699_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43703_1 | Australia | Australia | Australia |
SO43706_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43709_1 | Australia | Australia | Australia |
SO43712_1 | Germany | Germany | Germany |
SO43715_1 | Australia | Australia | Australia |
SO43718_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43721_1 | United Kingdom | United Kingdom | United Kingdom |
SO43726_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43727_1 | Australia | Australia | Australia |
SO43732_1 | Australia | Australia | Australia |
SO43733_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43738_1 | France | France | France |
SO43739_1 | United Kingdom | United Kingdom | United Kingdom |
SO43744_1 | Australia | Australia | Australia |
SO43745_1 | Australia | Australia | Australia |
SO43750_1 | France | France | France |
SO43751_1 | France | France | France |
SO43756_1 | United Kingdom | United Kingdom | United Kingdom |
SO43757_1 | Australia | Australia | Australia |
SO43762_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43763_1 | Australia | Australia | Australia |
SO43768_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43769_1 | Canada | Canada | Canada |
SO43778_1 | Australia | Australia | Australia |
SO43779_1 | Australia | Australia | Australia |
SO43780_1 | France | France | France |
SO43781_1 | Australia | Australia | Australia |
SO43790_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43791_1 | Australia | Australia | Australia |
SO43792_1 | Australia | Australia | Australia |
SO43793_1 | Australia | Australia | Australia |
SO43802_1 | France | France | France |
SO43803_1 | Canada | Canada | Canada |
SO43804_1 | United Kingdom | United Kingdom | United Kingdom |
SO43805_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43814_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43815_1 | Australia | Australia | Australia |
SO43816_1 | Australia | Australia | Australia |
SO43817_1 | Australia | Australia | Australia |
SO43826_1 | Australia | Australia | Australia |
SO43827_1 | Australia | Australia | Australia |
SO43828_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43829_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43838_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43839_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43840_1 | France | France | France |
SO43841_1 | Germany | Germany | Germany |
SO44409_1 | Australia | Australia | Australia |
SO44410_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44411_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2024-09-20 02:54:16.030 UTC