Abstract
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.
The universe is transformation; our life is what our thoughts make it. —Marcus Aurelius
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Randal Root and Caryn Mason
About this chapter
Cite this chapter
Root, R., Mason, C. (2012). ETL Processing with SQL. In: Pro SQL Server 2012 BI Solutions. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3489-0_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3489-0_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3488-3
Online ISBN: 978-1-4302-3489-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)