Microsoft Office Tutorials and References
In Depth Information
Now let’s see how to move your OLTP tables into an OLAP star schema. Because you chose tables in the Sales
module, let’s identify the key tables and data that need to be (or can be) analyzed. In a nutshell, you need to identify
one fact table and other dimension tables first for the Sales Repository (as you see in Figure 1-32 ).
Figure 1-32. Sales fact and dimension tables in a star schema
The idea is to extract data from the OLTP database, clean it a bit, and then load it to the model shown in
Figure 1-32 . The first step is to create all the tables in the star schema fashion.
Table 1-3 shows the tables you need to create in the AdventureWorksDW database. After you create them, move
the data in the corresponding tables of the AdventureWorks database to these newly created tables. So your first step
is to create these tables with the specified columns, data types, and keys. You can use the TSQL script “AWSalesTables.
sql” in the resources available with this topic to create the required tables.
Search JabSto ::