Database Reference
In-Depth Information
Summary
In this chapter, we specifically concentrated on a very important feature—SCD. We talked
about the different types of SCDs, that is, SCD1, SCD2, and SCD3. We saw in detail how
to use different transformations to achieve the SCD functionality. At the beginning of the
chapter, we used an example to understand the different types of SCDs. We learned how to
maintain only current data in SCD1. We checked for different forms of SCD2 mapping,
that is, using version number, flag, and date range. We checked how SCD3 maintains par-
tial data. We also checked how wizard creates different columns in different types of SCD
mapping.
