[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 438 > < TAKE 62 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
62 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44158_1 | Germany | Germany | Germany |
SO44159_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44160_1 | United States, Northwest | United States, Northwest | United States, Northwest |
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 |
SO44185_1 | Australia | Australia | Australia |
SO44186_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44187_1 | Australia | Australia | Australia |
SO44188_1 | United Kingdom | United Kingdom | United Kingdom |
SO44189_1 | United Kingdom | United Kingdom | United Kingdom |
SO44190_1 | Australia | Australia | Australia |
SO44191_1 | Australia | Australia | Australia |
SO44192_1 | Germany | Germany | Germany |
SO44209_1 | Australia | Australia | Australia |
SO44210_1 | United Kingdom | United Kingdom | United Kingdom |
SO44211_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44212_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44213_1 | Australia | Australia | Australia |
SO44214_1 | Australia | Australia | Australia |
SO44215_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44216_1 | Germany | Germany | Germany |
SO44217_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44218_1 | Canada | Canada | Canada |
SO44219_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44220_1 | Australia | Australia | Australia |
SO44221_1 | Australia | Australia | Australia |
SO44222_1 | Australia | Australia | Australia |
SO44223_1 | United Kingdom | United Kingdom | United Kingdom |
SO44224_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44225_1 | United Kingdom | United Kingdom | United Kingdom |
SO44226_1 | France | France | France |
SO44227_1 | France | France | France |
SO44228_1 | United Kingdom | United Kingdom | United Kingdom |
SO44229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44230_1 | Australia | Australia | Australia |
SO44231_1 | France | France | France |
SO44232_1 | Australia | Australia | Australia |
SO44233_1 | United Kingdom | United Kingdom | United Kingdom |
SO44234_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44235_1 | Canada | Canada | Canada |
SO44236_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44237_1 | Australia | Australia | Australia |
SO44238_1 | Australia | Australia | Australia |
SO44239_1 | France | France | France |
SO44240_1 | Germany | Germany | Germany |
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 |
SO44265_1 | Australia | Australia | Australia |
SO44266_1 | Australia | Australia | Australia |
SO44267_1 | Germany | Germany | Germany |
Generated 2024-09-19 23:50:12.915 UTC