[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 250  >   <  TAKE 31  >   TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales   

Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales

31 items

FactInternetSaleIdSalesTerritoryDimCustomer.DimGeography.DimSalesTerritory.NameDimSalesTerritory.Name
SO44138_1United KingdomUnited KingdomUnited Kingdom
SO44139_1United KingdomUnited KingdomUnited Kingdom
SO44140_1FranceFranceFrance
SO44141_1GermanyGermanyGermany
SO44142_1CanadaCanadaCanada
SO44143_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44144_1AustraliaAustraliaAustralia
SO43949_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43950_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43951_1AustraliaAustraliaAustralia
SO43952_1AustraliaAustraliaAustralia
SO43953_1United KingdomUnited KingdomUnited Kingdom
SO43954_1United KingdomUnited KingdomUnited Kingdom
SO43955_1United KingdomUnited KingdomUnited Kingdom
SO43956_1AustraliaAustraliaAustralia
SO43981_1AustraliaAustraliaAustralia
SO43982_1AustraliaAustraliaAustralia
SO43983_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO43984_1GermanyGermanyGermany
SO43985_1GermanyGermanyGermany
SO43986_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43987_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43988_1United KingdomUnited KingdomUnited Kingdom
SO43989_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43990_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO43991_1AustraliaAustraliaAustralia
SO43992_1AustraliaAustraliaAustralia
SO43993_1AustraliaAustraliaAustralia
SO43994_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO43995_1CanadaCanadaCanada
SO43996_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-11-10 04:01:48.633 UTC