CHAPTER 6
ETL Processing with SQL
The universe is transformation; our life is what our thoughts make it.
The ETL process, and projects associated with it, involve extracting vital information from outside sources, transforming data into clean, consistent, and usable data, and loading it into the data warehouse. This process is vital to the success of your BI solution. It is what makes the difference between a professional, functional data warehouse versus one that is messy, insufficient, and unusable. The ETL process is also one of the longest and most challenging steps in developing a BI solution.
In this chapter, we explain ...
Get Pro SQL Server 2012 BI Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.