Database Reference
In-Depth Information
Figure 9-11.
Changing the stock_date to the
Date
data type
Select the columns from
stock_price_open
to
stock_price_close
, and set their data type to
Decimal
as shown in
Figure
9-12
.
Figure 9-12.
Changing columns to the
Decimal
data type
Select the
stock_price_adj_close column
, and set its type to
Decimal
as well. Next, import the
DimDate
table from
AdventureWorksDWH
database in SQL Server to be able to create a date hierarchy. Click on
Get External Data
➤
From
Other Sources
➤
Microsoft SQL Server
, and provide the SQL Server connection details as shown in Figure
9-13
.