[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2550 > < TAKE 248 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
248 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47287_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47159_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46892_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47224_1 | Germany | Germany | Germany |
SO47288_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47160_1 | Australia | Australia | Australia |
SO46893_1 | Canada | Canada | Canada |
SO47225_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47289_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47161_1 | Australia | Australia | Australia |
SO46894_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47226_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47290_1 | Australia | Australia | Australia |
SO47162_1 | Australia | Australia | Australia |
SO46895_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47227_1 | Canada | Canada | Canada |
SO47291_1 | United Kingdom | United Kingdom | United Kingdom |
SO47163_1 | Australia | Australia | Australia |
SO46896_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47228_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47292_1 | France | France | France |
SO47164_1 | United Kingdom | United Kingdom | United Kingdom |
SO46897_1 | Australia | Australia | Australia |
SO47229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47293_1 | United Kingdom | United Kingdom | United Kingdom |
SO47165_1 | Germany | Germany | Germany |
SO46898_1 | Australia | Australia | Australia |
SO47230_1 | Australia | Australia | Australia |
SO47294_1 | Germany | Germany | Germany |
SO47166_1 | Germany | Germany | Germany |
SO46899_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47231_1 | Germany | Germany | Germany |
SO47295_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47167_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46900_1 | Australia | Australia | Australia |
SO47232_1 | Germany | Germany | Germany |
SO47296_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47168_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46901_1 | Australia | Australia | Australia |
SO47233_1 | United Kingdom | United Kingdom | United Kingdom |
SO47297_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47169_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46902_1 | Australia | Australia | Australia |
SO47234_1 | United Kingdom | United Kingdom | United Kingdom |
SO47298_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47170_1 | Australia | Australia | Australia |
SO46903_1 | Australia | Australia | Australia |
SO47235_1 | United Kingdom | United Kingdom | United Kingdom |
SO47299_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47171_1 | Australia | Australia | Australia |
SO46904_1 | France | France | France |
SO47236_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47300_1 | United Kingdom | United Kingdom | United Kingdom |
SO47172_1 | Australia | Australia | Australia |
SO46905_1 | United Kingdom | United Kingdom | United Kingdom |
SO47237_1 | Canada | Canada | Canada |
SO47301_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47173_1 | Australia | Australia | Australia |
SO46906_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47238_1 | United Kingdom | United Kingdom | United Kingdom |
SO47302_1 | Australia | Australia | Australia |
SO47174_1 | Australia | Australia | Australia |
SO46907_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47239_1 | Australia | Australia | Australia |
SO47303_1 | Australia | Australia | Australia |
SO47175_1 | France | France | France |
SO46908_1 | Australia | Australia | Australia |
SO47240_1 | Australia | Australia | Australia |
SO47304_1 | United Kingdom | United Kingdom | United Kingdom |
SO47176_1 | Germany | Germany | Germany |
SO46909_1 | Australia | Australia | Australia |
SO47241_1 | Australia | Australia | Australia |
SO47305_1 | Canada | Canada | Canada |
SO47177_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46910_1 | United Kingdom | United Kingdom | United Kingdom |
SO47242_1 | France | France | France |
SO47306_1 | Canada | Canada | Canada |
SO47178_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46911_1 | Canada | Canada | Canada |
SO47243_1 | United Kingdom | United Kingdom | United Kingdom |
SO47307_1 | United Kingdom | United Kingdom | United Kingdom |
SO47179_1 | Canada | Canada | Canada |
SO46912_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47244_1 | United Kingdom | United Kingdom | United Kingdom |
SO47308_1 | United Kingdom | United Kingdom | United Kingdom |
SO47180_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46913_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47245_1 | United Kingdom | United Kingdom | United Kingdom |
SO47309_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47181_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46914_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47246_1 | United Kingdom | United Kingdom | United Kingdom |
SO47310_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47182_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46915_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47247_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47311_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47183_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46916_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47248_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47312_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47184_1 | Australia | Australia | Australia |
SO46917_1 | Australia | Australia | Australia |
SO47249_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47313_1 | Australia | Australia | Australia |
SO47185_1 | United Kingdom | United Kingdom | United Kingdom |
SO46918_1 | Australia | Australia | Australia |
SO47250_1 | Australia | Australia | Australia |
SO47314_1 | Australia | Australia | Australia |
SO47186_1 | France | France | France |
SO46919_1 | Germany | Germany | Germany |
SO47251_1 | Australia | Australia | Australia |
SO47315_1 | France | France | France |
SO47187_1 | Germany | Germany | Germany |
SO46920_1 | United Kingdom | United Kingdom | United Kingdom |
SO47252_1 | Australia | Australia | Australia |
SO47316_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47188_1 | United Kingdom | United Kingdom | United Kingdom |
SO46921_1 | Germany | Germany | Germany |
SO47253_1 | Australia | Australia | Australia |
SO47317_1 | France | France | France |
SO47189_1 | Canada | Canada | Canada |
SO46922_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47318_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47190_1 | Canada | Canada | Canada |
SO46923_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47255_1 | Germany | Germany | Germany |
SO47319_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47191_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47256_1 | United Kingdom | United Kingdom | United Kingdom |
SO47320_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47192_1 | United Kingdom | United Kingdom | United Kingdom |
SO46925_1 | Australia | Australia | Australia |
SO47257_1 | France | France | France |
SO47321_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47193_1 | Germany | Germany | Germany |
SO46926_1 | Australia | Australia | Australia |
SO47258_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47322_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47194_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46927_1 | Australia | Australia | Australia |
SO47259_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47323_1 | France | France | France |
SO47195_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46928_1 | Australia | Australia | Australia |
SO47260_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47324_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47196_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47068_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47261_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47325_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47197_1 | Australia | Australia | Australia |
SO47069_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47262_1 | Australia | Australia | Australia |
SO47326_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47198_1 | France | France | France |
SO47070_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47263_1 | Australia | Australia | Australia |
SO47327_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47199_1 | Germany | Germany | Germany |
SO47071_1 | Germany | Germany | Germany |
SO47264_1 | United Kingdom | United Kingdom | United Kingdom |
SO47328_1 | Australia | Australia | Australia |
SO47200_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47072_1 | Germany | Germany | Germany |
SO47265_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47329_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47201_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47073_1 | Canada | Canada | Canada |
SO47633_1 | Australia | Australia | Australia |
SO47330_1 | United Kingdom | United Kingdom | United Kingdom |
SO47505_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47569_1 | Australia | Australia | Australia |
SO47634_1 | Germany | Germany | Germany |
SO47331_1 | United Kingdom | United Kingdom | United Kingdom |
SO47506_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47570_1 | France | France | France |
SO47635_1 | United Kingdom | United Kingdom | United Kingdom |
SO47332_1 | Canada | Canada | Canada |
SO47507_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47571_1 | France | France | France |
SO47636_1 | Australia | Australia | Australia |
SO47333_1 | Australia | Australia | Australia |
SO47508_1 | Australia | Australia | Australia |
SO47572_1 | Canada | Canada | Canada |
SO47637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47334_1 | Australia | Australia | Australia |
SO47509_1 | Australia | Australia | Australia |
SO47573_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47638_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47335_1 | Australia | Australia | Australia |
SO47510_1 | Australia | Australia | Australia |
SO47574_1 | Germany | Germany | Germany |
SO47639_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47336_1 | Australia | Australia | Australia |
SO47511_1 | France | France | France |
SO47575_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47640_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47337_1 | France | France | France |
SO47512_1 | United Kingdom | United Kingdom | United Kingdom |
SO47576_1 | Australia | Australia | Australia |
SO47513_1 | Germany | Germany | Germany |
SO47577_1 | Australia | Australia | Australia |
SO47514_1 | Germany | Germany | Germany |
SO47578_1 | Australia | Australia | Australia |
SO47515_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47579_1 | Germany | Germany | Germany |
SO47516_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47580_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47517_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47581_1 | Canada | Canada | Canada |
SO47518_1 | Australia | Australia | Australia |
SO47582_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47519_1 | Australia | Australia | Australia |
SO47583_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47520_1 | United Kingdom | United Kingdom | United Kingdom |
SO47584_1 | France | France | France |
SO47521_1 | United Kingdom | United Kingdom | United Kingdom |
SO47585_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47522_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47586_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47523_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47587_1 | Australia | Australia | Australia |
SO47524_1 | Australia | Australia | Australia |
SO47588_1 | United Kingdom | United Kingdom | United Kingdom |
SO47525_1 | Australia | Australia | Australia |
SO47589_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47526_1 | United Kingdom | United Kingdom | United Kingdom |
SO47590_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47527_1 | France | France | France |
SO47591_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47528_1 | Germany | Germany | Germany |
SO47592_1 | Australia | Australia | Australia |
SO47529_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47593_1 | Australia | Australia | Australia |
SO47530_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47594_1 | Australia | Australia | Australia |
SO47531_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47595_1 | France | France | France |
SO47532_1 | Australia | Australia | Australia |
SO47596_1 | Germany | Germany | Germany |
SO47533_1 | Australia | Australia | Australia |
SO47597_1 | Canada | Canada | Canada |
SO47534_1 | Australia | Australia | Australia |
SO47598_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47535_1 | United States, Northwest | United States, Northwest | United States, Northwest |
Generated 2025-07-07 23:56:19.835 UTC