[ROOT] dt FactInternetSale SELECT SalesTerritory, DimCustomer.DimGeography.DimSalesTerritory.Name, DimSalesTerritory.Name < SKIP 562 > < TAKE 31 > TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales
31 items
FactInternetSaleId | SalesTerritory | DimCustomer.DimGeography.DimSalesTerritory.Name | DimSalesTerritory.Name |
---|---|---|---|
SO44442_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44443_1 | Australia | Australia | Australia |
SO44444_1 | Germany | Germany | Germany |
SO44445_1 | Australia | Australia | Australia |
SO44446_1 | Australia | Australia | Australia |
SO44447_1 | France | France | France |
SO44448_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44571_1 | Germany | Germany | Germany |
SO44572_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44573_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44574_1 | Australia | Australia | Australia |
SO44575_1 | Australia | Australia | Australia |
SO44576_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44577_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44578_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44409_1 | Australia | Australia | Australia |
SO44410_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44411_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44412_1 | Australia | Australia | Australia |
SO44413_1 | Germany | Germany | Germany |
SO44414_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44415_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44416_1 | Australia | Australia | Australia |
SO44449_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44450_1 | United States, Southwest | United States, Southwest | United States, Southwest |
SO44451_1 | United States, Northwest | United States, Northwest | United States, Northwest |
SO44452_1 | United Kingdom | United Kingdom | United Kingdom |
SO44453_1 | Australia | Australia | Australia |
SO44454_1 | Australia | Australia | Australia |
SO44455_1 | Australia | Australia | Australia |
SO44456_1 | Australia | Australia | Australia |
Generated 2024-09-20 02:47:55.551 UTC