[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2617 > < TAKE 192 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
192 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO47164_1 | United Kingdom | United Kingdom | United Kingdom |
SO47468_1 | Australia | Australia | Australia |
SO47229_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47165_1 | Germany | Germany | Germany |
SO47469_1 | United Kingdom | United Kingdom | United Kingdom |
SO47230_1 | Australia | Australia | Australia |
SO47166_1 | Germany | Germany | Germany |
SO47470_1 | France | France | France |
SO47231_1 | Germany | Germany | Germany |
SO47167_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47471_1 | France | France | France |
SO47232_1 | Germany | Germany | Germany |
SO47168_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47472_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47233_1 | United Kingdom | United Kingdom | United Kingdom |
SO47169_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47473_1 | Australia | Australia | Australia |
SO47234_1 | United Kingdom | United Kingdom | United Kingdom |
SO47170_1 | Australia | Australia | Australia |
SO47474_1 | Australia | Australia | Australia |
SO47235_1 | United Kingdom | United Kingdom | United Kingdom |
SO47171_1 | Australia | Australia | Australia |
SO47475_1 | Australia | Australia | Australia |
SO47236_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47172_1 | Australia | Australia | Australia |
SO47476_1 | Australia | Australia | Australia |
SO47237_1 | Canada | Canada | Canada |
SO47173_1 | Australia | Australia | Australia |
SO47477_1 | France | France | France |
SO47238_1 | United Kingdom | United Kingdom | United Kingdom |
SO47174_1 | Australia | Australia | Australia |
SO47478_1 | United Kingdom | United Kingdom | United Kingdom |
SO47239_1 | Australia | Australia | Australia |
SO47175_1 | France | France | France |
SO47479_1 | United Kingdom | United Kingdom | United Kingdom |
SO47240_1 | Australia | Australia | Australia |
SO47176_1 | Germany | Germany | Germany |
SO47480_1 | Australia | Australia | Australia |
SO47241_1 | Australia | Australia | Australia |
SO47177_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47481_1 | Australia | Australia | Australia |
SO47242_1 | France | France | France |
SO47178_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47482_1 | Australia | Australia | Australia |
SO47243_1 | United Kingdom | United Kingdom | United Kingdom |
SO47179_1 | Canada | Canada | Canada |
SO47483_1 | France | France | France |
SO47244_1 | United Kingdom | United Kingdom | United Kingdom |
SO47180_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47484_1 | United Kingdom | United Kingdom | United Kingdom |
SO47245_1 | United Kingdom | United Kingdom | United Kingdom |
SO47181_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47485_1 | France | France | France |
SO47246_1 | United Kingdom | United Kingdom | United Kingdom |
SO47182_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47486_1 | France | France | France |
SO47247_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47183_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47487_1 | United Kingdom | United Kingdom | United Kingdom |
SO47248_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47184_1 | Australia | Australia | Australia |
SO47488_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47249_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47185_1 | United Kingdom | United Kingdom | United Kingdom |
SO47489_1 | Australia | Australia | Australia |
SO47250_1 | Australia | Australia | Australia |
SO47186_1 | France | France | France |
SO47490_1 | Australia | Australia | Australia |
SO47251_1 | Australia | Australia | Australia |
SO47187_1 | Germany | Germany | Germany |
SO47491_1 | Germany | Germany | Germany |
SO47252_1 | Australia | Australia | Australia |
SO47188_1 | United Kingdom | United Kingdom | United Kingdom |
SO47492_1 | France | France | France |
SO47253_1 | Australia | Australia | Australia |
SO47189_1 | Canada | Canada | Canada |
SO47493_1 | France | France | France |
SO47254_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47190_1 | Canada | Canada | Canada |
SO47494_1 | Germany | Germany | Germany |
SO47255_1 | Germany | Germany | Germany |
SO47191_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47495_1 | Germany | Germany | Germany |
SO47256_1 | United Kingdom | United Kingdom | United Kingdom |
SO47192_1 | United Kingdom | United Kingdom | United Kingdom |
SO47496_1 | United Kingdom | United Kingdom | United Kingdom |
SO47257_1 | France | France | France |
SO47193_1 | Germany | Germany | Germany |
SO47497_1 | France | France | France |
SO47258_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47194_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47498_1 | Canada | Canada | Canada |
SO47259_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47195_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47499_1 | Australia | Australia | Australia |
SO47260_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47196_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47500_1 | Australia | Australia | Australia |
SO47261_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47197_1 | Australia | Australia | Australia |
SO47501_1 | United Kingdom | United Kingdom | United Kingdom |
SO47262_1 | Australia | Australia | Australia |
SO47198_1 | France | France | France |
SO47502_1 | United Kingdom | United Kingdom | United Kingdom |
SO47263_1 | Australia | Australia | Australia |
SO47199_1 | Germany | Germany | Germany |
SO47503_1 | United Kingdom | United Kingdom | United Kingdom |
SO47264_1 | United Kingdom | United Kingdom | United Kingdom |
SO47200_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47504_1 | Germany | Germany | Germany |
SO47265_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47201_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47633_1 | Australia | Australia | Australia |
SO47569_1 | Australia | Australia | Australia |
SO47505_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47634_1 | Germany | Germany | Germany |
SO47570_1 | France | France | France |
SO47506_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47635_1 | United Kingdom | United Kingdom | United Kingdom |
SO47571_1 | France | France | France |
SO47507_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47636_1 | Australia | Australia | Australia |
SO47572_1 | Canada | Canada | Canada |
SO47508_1 | Australia | Australia | Australia |
SO47637_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47573_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47509_1 | Australia | Australia | Australia |
SO47638_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47574_1 | Germany | Germany | Germany |
SO47510_1 | Australia | Australia | Australia |
SO47639_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47575_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47511_1 | France | France | France |
SO47640_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47576_1 | Australia | Australia | Australia |
SO47512_1 | United Kingdom | United Kingdom | United Kingdom |
SO47641_1 | Canada | Canada | Canada |
SO47577_1 | Australia | Australia | Australia |
SO47513_1 | Germany | Germany | Germany |
SO47642_1 | France | France | France |
SO47578_1 | Australia | Australia | Australia |
SO47514_1 | Germany | Germany | Germany |
SO47643_1 | United Kingdom | United Kingdom | United Kingdom |
SO47579_1 | Germany | Germany | Germany |
SO47515_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47644_1 | Germany | Germany | Germany |
SO47580_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47516_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47645_1 | France | France | France |
SO47581_1 | Canada | Canada | Canada |
SO47517_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47646_1 | Canada | Canada | Canada |
SO47582_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47518_1 | Australia | Australia | Australia |
SO47647_1 | Australia | Australia | Australia |
SO47583_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47519_1 | Australia | Australia | Australia |
SO47648_1 | United Kingdom | United Kingdom | United Kingdom |
SO47584_1 | France | France | France |
SO47520_1 | United Kingdom | United Kingdom | United Kingdom |
SO47649_1 | United Kingdom | United Kingdom | United Kingdom |
SO47585_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47521_1 | United Kingdom | United Kingdom | United Kingdom |
SO47650_1 | United Kingdom | United Kingdom | United Kingdom |
SO47586_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47522_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47651_1 | Canada | Canada | Canada |
SO47587_1 | Australia | Australia | Australia |
SO47523_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47652_1 | United Kingdom | United Kingdom | United Kingdom |
SO47588_1 | United Kingdom | United Kingdom | United Kingdom |
SO47524_1 | Australia | Australia | Australia |
SO47653_1 | Germany | Germany | Germany |
SO47589_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47525_1 | Australia | Australia | Australia |
SO47654_1 | Australia | Australia | Australia |
SO47590_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO47526_1 | United Kingdom | United Kingdom | United Kingdom |
SO47655_1 | Australia | Australia | Australia |
SO47591_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47527_1 | France | France | France |
SO47656_1 | Australia | Australia | Australia |
SO47592_1 | Australia | Australia | Australia |
SO47528_1 | Germany | Germany | Germany |
SO47657_1 | Australia | Australia | Australia |
SO47593_1 | Australia | Australia | Australia |
SO47529_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47731_1 | United Kingdom | United Kingdom | United Kingdom |
SO47594_1 | Australia | Australia | Australia |
SO47530_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47732_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO47595_1 | France | France | France |
Generated 2025-07-13 01:01:47.275 UTC