Database Reference
In-Depth Information
Figure 1-2.
OLTP and data warehouse databases
Step 4: Create an ETL Process
Getting data from the original source to your data warehouse entails extracting the data from its original location,
transforming the data to be consistent with your new data warehouse design, and loading the data into the new
data warehouse location. This ETL process is discussed in great detail in Chapters 6, 7, and 8.
Although this process can be one of the most in-depth and complicated tasks in developing your BI solution,
Microsoft SQL Server 2012 provides invaluable tools to help you accomplish it, saving time and simplifying the
process for you. Using a combination of SQL programming and SQL Server's Integration Server (SSIS), you will
create an ETL process much like the one shown in Figure
1-3
.
