This chapter will guide you through the advanced ETL design methods. Most of them will utilize Data Services features and functionality already explained in the previous chapters. As you have probably noticed, there are many ways to do the same thing in Data Services. The methods and logic you apply to solve the specific problem often depend on environment characteristics and some other conditions, such as development resources and extract requirements applied to the source systems. On the contrary, some of the methods and techniques explained further do not depend on all these factors and could be considered as ETL development best practices.
In this chapter we will discuss a very popular method of populating slowly changing dimensions in data warehouse, which require the use of a combination of Data Services transforms and dataflow design techniques.
We will also review automatic recovery methods available in Data Services, which allow you to easily restart previously failed...