[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 2045 > < TAKE 12 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
12 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO46579_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46580_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46581_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46582_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46195_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46196_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO46197_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46198_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO46199_1 | Australia | Australia | Australia |
SO46200_1 | Australia | Australia | Australia |
SO46201_1 | Australia | Australia | Australia |
SO46202_1 | Australia | Australia | Australia |
Generated 2025-07-09 22:03:27.056 UTC