Database Reference
In-Depth Information
5.
in the “Select or enter database name” dropdown box, select the DwweatherTracker
database (Figure
2-19
).
6.
Now, test your connection using the Test button, and when it succeeds, close it by
clicking OK. Then click OK to close the Add Connection dialog window.
7.
Click the small arrow next to the DwweatherTracker database icon to expand Server
Explorer's list of database objects (Figure
2-21
).
Figure 2-21.
Viewing the tables and columns in DWWeatherTracker
8.
Click the small arrow next to the Tables folder to expand Server Explorer's list of
tables.
9. Click the small arrow next to the DimEvents table to expand the column listing.
10. Double-click the file
WeatherTrackerETLPlan.xls
in Solution Explorer. This
opens an Excel window.
11. verify that the tables are properly made by comparing them to the Excel
spreadsheet, as shown in Figure
2-22
.
