[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 563  >   <  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
SO44425_1AustraliaAustraliaAustralia
SO44458_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44442_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44426_1GermanyGermanyGermany
SO44459_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44443_1AustraliaAustraliaAustralia
SO44427_1United KingdomUnited KingdomUnited Kingdom
SO44460_1United KingdomUnited KingdomUnited Kingdom
SO44444_1GermanyGermanyGermany
SO44428_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44461_1AustraliaAustraliaAustralia
SO44445_1AustraliaAustraliaAustralia
SO44429_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44462_1United KingdomUnited KingdomUnited Kingdom
SO44446_1AustraliaAustraliaAustralia
SO44430_1AustraliaAustraliaAustralia
SO44463_1GermanyGermanyGermany
SO44447_1FranceFranceFrance
SO44431_1AustraliaAustraliaAustralia
SO44464_1CanadaCanadaCanada
SO44448_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44432_1United KingdomUnited KingdomUnited Kingdom
SO44603_1United KingdomUnited KingdomUnited Kingdom
SO44587_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44571_1GermanyGermanyGermany
SO44604_1GermanyGermanyGermany
SO44588_1CanadaCanadaCanada
SO44572_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44605_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44589_1AustraliaAustraliaAustralia
SO44573_1United States, SouthwestUnited States, SouthwestUnited States, Southwest

Generated 2024-11-10 07:29:11.746 UTC