[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 813 > < TAKE 124 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
124 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44878_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44879_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44880_1 | Australia | Australia | Australia |
SO44881_1 | Australia | Australia | Australia |
SO44882_1 | Australia | Australia | Australia |
SO44883_1 | Australia | Australia | Australia |
SO44884_1 | Australia | Australia | Australia |
SO44885_1 | United Kingdom | United Kingdom | United Kingdom |
SO44886_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44887_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44888_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44889_1 | United Kingdom | United Kingdom | United Kingdom |
SO44922_1 | Australia | Australia | Australia |
SO44923_1 | Australia | Australia | Australia |
SO44924_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44925_1 | Australia | Australia | Australia |
SO44926_1 | Australia | Australia | Australia |
SO44927_1 | Australia | Australia | Australia |
SO44928_1 | United Kingdom | United Kingdom | United Kingdom |
SO44929_1 | France | France | France |
SO44930_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44931_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44932_1 | Australia | Australia | Australia |
SO44933_1 | Australia | Australia | Australia |
SO44934_1 | United Kingdom | United Kingdom | United Kingdom |
SO44935_1 | France | France | France |
SO44936_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44937_1 | Canada | Canada | Canada |
SO44938_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44939_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44940_1 | Australia | Australia | Australia |
SO44941_1 | Australia | Australia | Australia |
SO44942_1 | Australia | Australia | Australia |
SO44943_1 | Australia | Australia | Australia |
SO44944_1 | Australia | Australia | Australia |
SO44945_1 | Australia | Australia | Australia |
SO44946_1 | Australia | Australia | Australia |
SO44947_1 | Australia | Australia | Australia |
SO44948_1 | France | France | France |
SO44949_1 | Germany | Germany | Germany |
SO44950_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44951_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44952_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44953_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44986_1 | Australia | Australia | Australia |
SO44987_1 | France | France | France |
SO44988_1 | France | France | France |
SO44989_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44990_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44991_1 | Australia | Australia | Australia |
SO44992_1 | Australia | Australia | Australia |
SO44993_1 | Australia | Australia | Australia |
SO44994_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44995_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44996_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44997_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44998_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44999_1 | Australia | Australia | Australia |
SO45000_1 | Australia | Australia | Australia |
SO45001_1 | Australia | Australia | Australia |
SO45002_1 | Germany | Germany | Germany |
SO45003_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45004_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45005_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45006_1 | France | France | France |
SO45007_1 | Germany | Germany | Germany |
SO45008_1 | United Kingdom | United Kingdom | United Kingdom |
SO45009_1 | Germany | Germany | Germany |
SO45010_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45011_1 | Canada | Canada | Canada |
SO45012_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45013_1 | Australia | Australia | Australia |
SO45014_1 | Australia | Australia | Australia |
SO45015_1 | Australia | Australia | Australia |
SO45016_1 | United Kingdom | United Kingdom | United Kingdom |
SO45017_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45090_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45091_1 | Australia | Australia | Australia |
SO45092_1 | Australia | Australia | Australia |
SO45093_1 | Australia | Australia | Australia |
SO45094_1 | Canada | Canada | Canada |
SO45095_1 | United Kingdom | United Kingdom | United Kingdom |
SO45096_1 | France | France | France |
SO45097_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44898_1 | Australia | Australia | Australia |
SO44899_1 | United Kingdom | United Kingdom | United Kingdom |
SO44900_1 | United Kingdom | United Kingdom | United Kingdom |
SO44901_1 | France | France | France |
SO44902_1 | Germany | Germany | Germany |
SO44903_1 | Australia | Australia | Australia |
SO44904_1 | Australia | Australia | Australia |
SO44905_1 | Germany | Germany | Germany |
SO44954_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44955_1 | Australia | Australia | Australia |
SO44956_1 | Australia | Australia | Australia |
SO44957_1 | Canada | Canada | Canada |
SO44958_1 | United Kingdom | United Kingdom | United Kingdom |
SO44959_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44960_1 | Canada | Canada | Canada |
SO44961_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44962_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44963_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44964_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44965_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44966_1 | Australia | Australia | Australia |
SO44967_1 | United Kingdom | United Kingdom | United Kingdom |
SO44968_1 | Germany | Germany | Germany |
SO44969_1 | Canada | Canada | Canada |
SO45018_1 | Australia | Australia | Australia |
SO45019_1 | Australia | Australia | Australia |
SO45020_1 | Australia | Australia | Australia |
SO45021_1 | Australia | Australia | Australia |
SO45022_1 | Australia | Australia | Australia |
SO45023_1 | Germany | Germany | Germany |
SO45024_1 | Germany | Germany | Germany |
SO45025_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO45026_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45027_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO45028_1 | Australia | Australia | Australia |
SO45029_1 | Australia | Australia | Australia |
SO45030_1 | Australia | Australia | Australia |
SO45031_1 | United Kingdom | United Kingdom | United Kingdom |
SO45032_1 | Germany | Germany | Germany |
SO45033_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2025-04-06 09:42:19.846 UTC