Database Reference
In-Depth Information
2. Right-click on the Designer view and choose
Add/Remove Tables
.
3. Add the following tables to your Data Source View:
•
FactResellerSales
•
DimEmployee
•
DimReseller
•
DimGeography
•
DimSalesReason
•
FactInternetSalesReason
4. Create a relationship between the following columns by dragging columns
from the
FactResellerSales
table to the
DimDate
table:
FactResellerSales
DimDate
OrderDateKey
DateKey
DueDateKey
DateKey
Search WWH ::
Custom Search