Abstract
Projects that require bringing together data from multiple sources—for example, data warehouse, data mart, or operational data store (ODS) projects—are extremely common. You could spend months gathering business requirements, putting together technical specifications, designing target databases, and coding and testing your ETL process. You could spend an eternity in “ad hoc maintenance mode” rewriting large sections of code that don’t handle unanticipated bad or nonconforming data. This scenario is the result of a failure to properly plan and execute data intergration projects—a phenomenon known as code, load, and explode.
Code, load, and explode.—Steve Hitchman
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 Francis Rodrigues, Michael Coles, and David Dye
About this chapter
Cite this chapter
Rodrigues, F., Coles, M., Dye, D. (2012). Data Profiling and Scrubbing. In: Pro SQL Server 2012 Integration Services. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3693-1_12
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3693-1_12
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3692-4
Online ISBN: 978-1-4302-3693-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books