Abstract
Processing Slowly Changing Dimensions (SCDs) is a common ETL operation when dealing with Data Warehouses. The SSIS Data Flow has a Slowly Changing Dimension Transform, which provides a wizard that outputs a set of transforms needed to handle the multiple steps of processing SCDs. While the built-in SCD Transform can be useful, it is not ideal for all data loading scenarios. This chapter describes how to make the most of the SCD Transform, and provides a couple of alternative patterns you can use.
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 Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford
About this chapter
Cite this chapter
Leonard, A., Masson, M., Mitchell, T., Moss, J.M., Ufford, M. (2012). Slowly Changing Dimensions. In: SQL Server 2012 Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3772-3_13
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3772-3_13
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3771-6
Online ISBN: 978-1-4302-3772-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books