[ROOT]  dt  FactInternetSale  SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name   <  SKIP 500  >   <  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
SO44249_1United KingdomUnited KingdomUnited Kingdom
SO44470_1AustraliaAustraliaAustralia
SO44022_1CanadaCanadaCanada
SO44454_1AustraliaAustraliaAustralia
SO44250_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44471_1AustraliaAustraliaAustralia
SO44023_1CanadaCanadaCanada
SO44455_1AustraliaAustraliaAustralia
SO44251_1United States, SouthwestUnited States, SouthwestUnited States, Southwest
SO44472_1GermanyGermanyGermany
SO44024_1AustraliaAustraliaAustralia
SO44456_1AustraliaAustraliaAustralia
SO44252_1United KingdomUnited KingdomUnited Kingdom
SO44025_1AustraliaAustraliaAustralia
SO44026_1AustraliaAustraliaAustralia
SO44027_1CanadaCanadaCanada
SO44028_1AustraliaAustraliaAustralia
SO44029_1AustraliaAustraliaAustralia
SO44030_1FranceFranceFrance
SO44031_1United KingdomUnited KingdomUnited Kingdom
SO44032_1United KingdomUnited KingdomUnited Kingdom
SO44053_1GermanyGermanyGermany
SO44054_1GermanyGermanyGermany
SO44055_1GermanyGermanyGermany
SO44056_1GermanyGermanyGermany
SO44057_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44058_1AustraliaAustraliaAustralia
SO44059_1AustraliaAustraliaAustralia
SO44060_1AustraliaAustraliaAustralia
SO44061_1United States, NorthwestUnited States, NorthwestUnited States, Northwest
SO44062_1United States, NorthwestUnited States, NorthwestUnited States, Northwest

Generated 2024-11-10 02:54:50.729 UTC