In this chapter, we learned why data is transformed. It is important to remember that we should not fully put our faith in incoming data from external sources. As well as this, we need to make many checks on incoming data, and we also need to adjust the data format to fit our expectations.
When the reason for data transformation was found, we went through several architectures suitable for data transformation in one or more steps. When the architecture was described, we learned how to transform data using tools such as SSIS or T-SQL.
Two sections of this chapter guided us through data transformation tasks with designing and implementing denormalization using ad hoc queries and procedural objects.
The last section was dedicated to recommended practices and indexing techniques for the best performance of our transformation jobs.
The following chapter will focus on discovering...