[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 312 > < TAKE 62 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
62 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44224_1 | United States, Southwest | United States, Southwest | United States, Southwest |
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 |
SO44244_1 | Australia | Australia | Australia |
SO44245_1 | Australia | Australia | Australia |
SO44246_1 | France | France | France |
SO44247_1 | Australia | Australia | Australia |
SO44248_1 | Australia | Australia | Australia |
SO44013_1 | Australia | Australia | Australia |
SO44021_1 | Australia | Australia | Australia |
SO44014_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44022_1 | Canada | Canada | Canada |
SO44015_1 | United Kingdom | United Kingdom | United Kingdom |
SO44023_1 | Canada | Canada | Canada |
SO44016_1 | United Kingdom | United Kingdom | United Kingdom |
SO44024_1 | Australia | Australia | Australia |
SO44017_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44025_1 | Australia | Australia | Australia |
SO44018_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44026_1 | Australia | Australia | Australia |
SO44019_1 | Australia | Australia | Australia |
SO44027_1 | Canada | Canada | Canada |
SO44020_1 | Australia | Australia | Australia |
SO44028_1 | Australia | Australia | Australia |
SO44053_1 | Germany | Germany | Germany |
SO44061_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44054_1 | Germany | Germany | Germany |
SO44062_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44055_1 | Germany | Germany | Germany |
SO44063_1 | United Kingdom | United Kingdom | United Kingdom |
SO44056_1 | Germany | Germany | Germany |
SO44064_1 | Canada | Canada | Canada |
SO44057_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44065_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44058_1 | Australia | Australia | Australia |
SO44066_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44059_1 | Australia | Australia | Australia |
SO44067_1 | Australia | Australia | Australia |
SO44060_1 | Australia | Australia | Australia |
SO44068_1 | Germany | Germany | Germany |
SO44145_1 | Australia | Australia | Australia |
SO44153_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44146_1 | Australia | Australia | Australia |
SO44154_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44147_1 | Australia | Australia | Australia |
SO44155_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44148_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44156_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44149_1 | Australia | Australia | Australia |
SO44157_1 | Australia | Australia | Australia |
SO44150_1 | Australia | Australia | Australia |
SO44158_1 | Germany | Germany | Germany |
SO44151_1 | Australia | Australia | Australia |
SO44159_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44152_1 | United Kingdom | United Kingdom | United Kingdom |
SO44160_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44161_1 | United Kingdom | United Kingdom | United Kingdom |
SO44169_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44162_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44170_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44163_1 | United States, Southwest | United States, Southwest | United States, Southwest |
Generated 2024-09-20 00:44:06.159 UTC