[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 248 > < TAKE 124 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
124 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44068_1 | Germany | Germany | Germany |
SO44137_1 | Australia | Australia | Australia |
SO44138_1 | United Kingdom | United Kingdom | United Kingdom |
SO44139_1 | United Kingdom | United Kingdom | United Kingdom |
SO44140_1 | France | France | France |
SO44141_1 | Germany | Germany | Germany |
SO44142_1 | Canada | Canada | Canada |
SO44143_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44144_1 | Australia | Australia | Australia |
SO43941_1 | United Kingdom | United Kingdom | United Kingdom |
SO43942_1 | Australia | Australia | Australia |
SO43943_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43944_1 | Australia | Australia | Australia |
SO43945_1 | Australia | Australia | Australia |
SO43946_1 | Australia | Australia | Australia |
SO43947_1 | Australia | Australia | Australia |
SO43948_1 | Australia | Australia | Australia |
SO43957_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43958_1 | Australia | Australia | Australia |
SO43959_1 | Australia | Australia | Australia |
SO43960_1 | Australia | Australia | Australia |
SO43961_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43962_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43963_1 | Australia | Australia | Australia |
SO43964_1 | Australia | Australia | Australia |
SO43989_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43990_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO43991_1 | Australia | Australia | Australia |
SO43992_1 | Australia | Australia | Australia |
SO43993_1 | Australia | Australia | Australia |
SO43994_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO43995_1 | Canada | Canada | Canada |
SO43996_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44013_1 | Australia | Australia | Australia |
SO44014_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44015_1 | United Kingdom | United Kingdom | United Kingdom |
SO44016_1 | United Kingdom | United Kingdom | United Kingdom |
SO44017_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44018_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44019_1 | Australia | Australia | Australia |
SO44020_1 | Australia | Australia | Australia |
SO44021_1 | Australia | Australia | Australia |
SO44022_1 | Canada | Canada | Canada |
SO44023_1 | Canada | Canada | Canada |
SO44024_1 | Australia | Australia | Australia |
SO44025_1 | Australia | Australia | Australia |
SO44026_1 | Australia | Australia | Australia |
SO44027_1 | Canada | Canada | Canada |
SO44028_1 | Australia | Australia | Australia |
SO44045_1 | France | France | France |
SO44046_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44047_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44048_1 | Australia | Australia | Australia |
SO44049_1 | Germany | Germany | Germany |
SO44050_1 | Australia | Australia | Australia |
SO44051_1 | United Kingdom | United Kingdom | United Kingdom |
SO44052_1 | Australia | Australia | Australia |
SO44069_1 | France | France | France |
SO44070_1 | Canada | Canada | Canada |
SO44071_1 | Australia | Australia | Australia |
SO44072_1 | Australia | Australia | Australia |
SO44073_1 | Australia | Australia | Australia |
SO44134_1 | United Kingdom | United Kingdom | United Kingdom |
SO44135_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44136_1 | Canada | Canada | Canada |
SO44153_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44154_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44155_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44156_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44157_1 | Australia | Australia | Australia |
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 |
SO44145_1 | Australia | Australia | Australia |
SO44146_1 | Australia | Australia | Australia |
SO44147_1 | Australia | Australia | Australia |
SO44148_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44149_1 | Australia | Australia | Australia |
SO44150_1 | Australia | Australia | Australia |
SO44151_1 | Australia | Australia | Australia |
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 |
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 |
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 |
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 |
Generated 2024-09-20 02:32:41.349 UTC